Query Performance

Question

I have large no record how to get the performance to retrieve the data

Jignesh Trivedi · Answer

hi Kunal 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.