Query Performance
I have large no record how to get the performance to retrieve the data
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jun 7, 2012, 11:31 PM
For Tune Sql Query,
Create Highly-Selective Indexes
Create Multiple-Column Indexes
Indexes on these keys lets the optimizer consider more efficient index join algorithms. If your query joins tables by using other columns, it is frequently helpful to create indexes on those columns.
Also Look Execution plan for your query in SSMS it also suggest Index.
also refer
http://www.scarydba.com/wp-content/uploads/2011/05/Query-Performance-Tuning-Start-To-Finish-Rally.pdf
http://msdn.microsoft.com/en-us/library/ms187830%28v=sql.105%29.aspx
hope this will help you.