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 |
|
sunanda
Starting Member
2 Posts |
 Posted - 2008-05-04 : 05:30:33
|
| how to estimate query plan costpls hepl mi out 4 dis urgently |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-04 : 05:49:55
|
| Just select the option in Query Analyzer or Management Studio to include the estimated execution plan or the actual one. The estimated one is good for when you don't want to actually run the query. The actual one and estimated can be different though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
eralper
Yak Posting Veteran
66 Posts |
Posted - 2008-05-07 : 10:03:53
|
| If you highlight the query and select "Display Estimated Execution Plan" from the context menu (or right click menu), you can display it on the SQL Server Management Studio or on the Query Editor for SQL2000Eralper[url]http://www.kodyaz.com/content/SQLServerArticles.aspx[/url]-------------Eralperhttp://www.kodyaz.com |
|
|
|
|
|
|
25fe