Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Daniel Israel
Starting Member
15 Posts |
 Posted - 2008-05-19 : 14:13:10
|
| Is there some equivalent to MySQL's EXPLAIN function? (or some utility that does the same thing?)Basically the function takes a query and will return a list of the tables in the query and the number of rows that would need to be checked. It's used to check how well the indexes are set. (If a table returns a very high number, that could be a bottleneck for the query).Any help is appreciated. Thanks.-D. Israel |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-19 : 14:53:16
|
| Set Showplan_text ongo<query>See showplan in BOLAn infinite universe is the ultimate cartesian product. |
 |
|
|
|
|
|
EXPLAIN function