Last post Feb 23, 2017 12:51 PM by PatriceSc
Feb 23, 2017 10:06 AM|mamoni.kol2017|LINK
suppose i have table and when i am fetching data from that table it takes long time.
this kind of question i was asked in interview and interview ask me what will be your approach to find out the reason for slow query.
so tell me what approach one should takes one after one to investigate this kind of problem. thanks
Feb 23, 2017 12:51 PM|PatriceSc|LINK
The first step would be to see if it really comes from the query. For example on the web you see sometimes one that tries to show a huge 10000 rows+ table and the poor performance is rather caused by downloading a huge HTML page rather than by the server
Then beyond basic stuff (do I have an index on columns used in my WHERE clause ?) it's likeky best to relies on available tools such as
https://msdn.microsoft.com/en-us/library/ms187735.aspx to see first what happens exactly rather than trying to guess or to apply blindly some kind of full check list that may or may not include
your actual issue.