I have SQL server table with 15,000 rows. When I try "select * from tbl name" , it takes minutes to return results instead of seconds.
This table is main driving table . Due to time it is taking to execute SQL, I often see bad response time at front end with deadlock issues reported.
There are around 16 Indexes on table. All of them are reorganised and with no fragmentation reported. Why it is not using any of them? See attached snap for details.