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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-06-02 : 13:49:15
|
| Hi,I did DBCC SHOW_STATISTICS on the following:Per BOL description, I am unable to comprehend what to interpret from the below result: I only understood the first row.Statistics for INDEX 'PS_PAY_CHECK'.Updated Rows Rows Sampled Steps Density Average key length -------------------- -------------------- -------------------- ------ Jun 1 2003 7:25PM 1836961 1836961 4 0.0 21.0(1 row(s) affected)All density Average Length Columns -------------------------------------0.25 3.0 COMPANY0.11111111 6.0 COMPANY, PAYGROUP5.0607289E-4 14.0 COMPANY, PAYGROUP, PAY_END_DT3.3311127E-4 15.0 COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE2.1884327E-6 17.0 COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM5.5129408E-7 19.0 COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM5.4437737E-7 21.0 COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM, SEPCHK----RANGE RANGE EQ DISTINCT AVG_RANGEHI_KEY ROWS ROWS RANGE_ROWS ROWS-------------------------------------------------ASH 0.0 15287.0 0 0.0DTC 0.0 1813199.0 0 0.0MI1 0.0 4241.0 0 0.0MI2 0.0 4234.0 0 0.0----------------What should I know from this?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-06-02 : 13:59:17
|
| This should helpStatistics Used by the Query Optimizer in Microsoft SQL Server 2000[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
|
|
Understnading Statistics