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