How to check query optimization

Click here to hide categories Click here to show left categories

User: Home welcome : Guest Log In / Register here

Asp.Net 2.0

C++ Programs/Algorithms

ASP.NET 2.0 & 3.5 / Ajax

Design Patterns

Website Hosting

.Net Video Tutorials

jQuery & ASP.NET

General Concepts

C++ Concepts

Usable Codes

Google Stuff

Tips & Tricks (Fun Stuff)

Errors : Asp.Net

Errors : Sql Server

Software Testing

Data Structures

Data Structures Programs/Algorithms

Quick Test Professional (QTP)

C# Interview questions

C# Interview

Technical Analysis

How to check query optimization



1. Create Index 2. Primary Key Creation 3. Joins instead of sub queries 4. Select column names instead of * 5. First n rows where order by is used 6. No usage of cursors




Share this article \| Print \| Article read by 1712 times
Author: Guest Guest user is that user who have done some activity on website without login. Activity contains commenting on any article, uploading an image on website etc.	Related Articles: No related article Related Interview Questions: No related interview question