Loading

How to improve table(15Lacs records) in Sqlserver2008R2 ?

s kumar

12y1.4k

Hi,

I have one table named "tblSeacrch" in Sqlserver2008R2. In that table have 15Lacs records. When fetch all records then It Takes 10mins to display.

Another one When display 15Lac records in RDLC Report then Page is loading.

How to improve performance in table? I don't know anything. Please Let me know.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Hanook12y ago
Try to execute query in SSMS after clicking Ctrl+M so that you can get the execution plan... One input is create index on the columns that are used in the WHERE condition Analyse the execution plan for which part is consuming more time
0