I have this table, which has just 700 rows. Doing select * on it is taking considerable time. More than a minute to fetch first 40 rows..2 mins to fetch 80 rows likewise.. I tried updating statistics, added primary key column, there is no blocking query running parallelly.
But no performance improvement. Only select on this table is slow. Could it be due to xml based column which has query plan and sql_command column which has sql command executed? Should i check for other things?
How can i improve the performance of this query?
1