In MySQL we can use EXPLAIN {query} and we can get a nice grip on the performance of the said query. I want to help a friend who works with MSSQL and I don't know what is the equivalent or if there is one for the EXPLAIN keyword. EXPLAIN is a synonym with DESCRIBE
Asked
Active
Viewed 1,277 times
0
-
1http://stackoverflow.com/questions/3449814/sql-server-equivelant-to-mysqls-explain – A_Sk Feb 26 '15 at 10:10
-
this question was answered http://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan – rpc1 Feb 26 '15 at 10:22
-
MS Sql Server :equivalent of DESC is SP_HELP – Joe Taras Feb 26 '15 at 10:55