Explain Details about SQL Server Query Optimization?
-- Sql Database with fast Response
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.
NitinPosted Apr 16, 2015, 6:25 AM
1. Try avoiding * in your select queries. Specify the columns that you wish to fetch.
2. Create a Primary key in the table. This will automatically create a clustered index.
3. When using joins fetch the column to join the table instead of pulling all the rows.
4. Use Stored Procedures instead of inline queries as they have cache specific features.
5. You can go for non clustered indexes. But you should choose them wisely.