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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-02-14 : 10:06:12
|
| Hi i have run the showcontigType 2 1Rows 10000 10000Pages Scanned 23 10000Size 80656 80656Pages Scanned / 8 kb Extents Scanned 3 1254One Less than Extents Switched Extents Switched 2 1253(8 Kb) lower Pages/Extent 7 8I was wondering how the 23 is calculated.The index non clustered is int of 4 bytes and i have 10000 rowsThank you |
|
|
|
|
|
DBCC showcontig