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 |
|
ConfusedOfLife
Starting Member
35 Posts |
 Posted - 2002-11-11 : 03:09:10
|
| What's this subtree cost that everyone's talking about?! I think it just defines the depth?? of your subqueries and how fast they run, is it any article that I can read about it? How can see my queries subtree cost and how can I optimize them? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-11-11 : 03:37:42
|
quote:
What's this subtree cost that everyone's talking about?! I think it just defines the depth?? of your subqueries and how fast they run, is it any article that I can read about it? How can see my queries subtree cost and how can I optimize them?
Before you run the query in query analyzer, go to the Query menu and select "show execution plan". Then after you run the query there will be another tab in the results where you can see the execution plan, and you can look at the subtree cost by letting the mouse hover over the query to the left. |
 |
|
|
|
|
|
What's this subtree cost?!