Check the following scenarions :
Your table may be LOCKED/BLOCKED by some session/resource.
Your table may be heavily FRAGMENTED.
Your table may have Complex COMPUTED columns.
Your table may have Millions of records(It will use more IO).
Your table may have more COLUMNS ( If I used '*' ).
Your table may have more COLUMN with BLOB like Type.
We can use WHERE Clause with Clustered Index (If required)So that optimizer don't want to search all Datapages.
If the Table have any INDEX , The FILLFACTOR may be very HIGH. So that the READING and Posting data into cache operation will wait for some more Free space.
The reasons given above may be a one of reason why your query is Slow.
CheersSarvesh, if this helps please login to Mark As Answer. | Alert Moderator