Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




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 932 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