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 |
|
kumarpav
Starting Member
18 Posts |
 Posted - 2004-12-26 : 02:00:11
|
| Hi, What is Cost Based Optimization and Rule based optimization..How to find Cost of a query? |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-26 : 05:57:14
|
| SET STATISTICS IO ONSET STATISTICS TIME ON... put query hereSET STATISTICS IO OFFSET STATISTICS TIME OFFyou probably need to view results in TEXT mode (in QA), rather than GRID mode. Keep an eye on the Logical IO (rather than the physical IO)You can clear cache (for level playing field) and to get some physical IO figures, but do **NOT** run these on a Live server!DBCC DROPCLEANBUFFERSDBCC FREEPROCCACHEIf you want to see the query plan substitute the command above with:SET SET SHOWPLAN_TEXT ONGO... put query hereGOSET SET SHOWPLAN_TEXT OFFGOSee http://www.sql-server-performance.com/statistics_io_time.asp for more detailsKristen |
 |
|
|
|
|
|
Performance Enhancements