Explain Details about SQL Server Query Optimization?

Question

-- Sql Database with fast Response

Nitin · Answer

Hello 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.