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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-11-10 : 06:21:18
|
| Hi,I have taken showcontig report for a table before and after dbreindex.Need explanation about each terms in showcontig for better performance.Compare the report and say will improve the performance now after doing the dbreindex.Fragmentation also reduced, so is not neccessary to do the defragmentation????--AFTER REINDEXTable: 'Quotation' (312388182); index ID: 1, database ID: 11TABLE level scan performed.- Pages Scanned................................: 2406168- Extents Scanned..............................: 301411- Extent Switches..............................: 301410- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 99.79% [300771:301411]- Logical Scan Fragmentation ..................: 0.00%- Extent Scan Fragmentation ...................: 0.42%- Avg. Bytes Free per Page.....................: 814.1- Avg. Page Density (full).....................: 89.94%--BEFORE REINDEXTable: 'Quotation' (312388182); index ID: 1, database ID: 11TABLE level scan performed.- Pages Scanned................................: 3417340- Extents Scanned..............................: 428596- Extent Switches..............................: 2151253- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 19.86% [427168:2151254]- Logical Scan Fragmentation ..................: 32.10%- Extent Scan Fragmentation ...................: 0.83%- Avg. Bytes Free per Page.....................: 2965.6- Avg. Page Density (full).....................: 63.36% |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-10 : 23:20:52
|
| Rebuild clustered index does defrag table. |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-11-12 : 01:30:02
|
| "Rebuild clustered index does defrag table."Rmiao .. i could not get.. can you please explain .. |
|
|
|
Ankit Mathur
Starting Member
24 Posts |
Posted - 2007-11-12 : 02:38:01
|
| DBCC REINDEX performs a database reorganization on all the indexes on all the tables in your database. This will rebuild the indexes so that the data is no longer fragmented. If you perform a reorganization on a table with a clustered index, any non-clustered indexes on that same table will automatically be rebuilt.Example:DBCC DBREINDEX('table_name', fillfactor) |
|
|
|
|
|
|
dbcc showcontig