|
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
Contributed by:
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.
Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=197
Click here to go on website
|