Gagan Sharma

Gagan Sharma

  • 691
  • 2.7k
  • 571.6k

Large Table data fetch issue

Jan 26 2018 11:10 PM
Hi All,
 
I have a table with more than 45 lakh entries in it.
 
The table has only 2 columns, that are properly indexed(cluster and nonclustered), Fragmentation on the indexes are only around 5%. I have rebuilded/reorganised the index already.
 
When i fetch all records from the table it take more than 51 seconds.
 
Even in the SP's it hurts the performence so badly, as it is joined with other tables 
 
How do i solve this issue? 
 
 
 

Answers (4)