|
Home > Archive > MS SQL Server > October 2006 > Unable to rebuild non-clustered indexes usng DBCC DBREINDEX.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unable to rebuild non-clustered indexes usng DBCC DBREINDEX.
|
|
| csajid@gmail.com 2006-10-28, 7:14 pm |
| Hi,
I am using MS SQL Server 2000 Enterprise edition with no SP.
In one of my database i have one table Mytable on which we four
non-clustered indexes.
when i issue dbcc showcontig command it is showing below output.
DBCC SHOWCONTIG scanning 'Mytable' table...
Table: 'IRR' (117575457); index ID: 0, database ID: 8
TABLE level scan performed.
- Pages Scanned................................: 36094
- Extents Scanned..............................: 5341
- Extent Switches..............................: 5340
- Avg. Pages per Extent........................: 6.8
- Scan Density [Best Count:Actual Count].......: 84.48% [4512:5341]
- Extent Scan Fragmentation ...................: 11.18%
- Avg. Bytes Free per Page.....................: 843.4
- Avg. Page Density (full).....................: 89.58%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
After execution of DBCC DBREINDEX ('MF.dbo.Mytable')
it is giving me same output as of above.
I also tried DBCC indexdefrag but, of no use.
Please help me.
Thanks & Regards,
Sajid C.
| |
| Tibor Karaszi 2006-10-28, 7:14 pm |
| You are looking at indexid 0. This means that the table doesn't have a clustered index, and you are
looking at the data pages, for which there is no order between the pages. So, fragmentation doesn't
apply for data pages in a heap.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
<csajid@gmail.com> wrote in message news:1161851618.291677.8560@i42g2000cwa.googlegroups.com...
> Hi,
>
> I am using MS SQL Server 2000 Enterprise edition with no SP.
> In one of my database i have one table Mytable on which we four
> non-clustered indexes.
> when i issue dbcc showcontig command it is showing below output.
>
> DBCC SHOWCONTIG scanning 'Mytable' table...
> Table: 'IRR' (117575457); index ID: 0, database ID: 8
> TABLE level scan performed.
> - Pages Scanned................................: 36094
> - Extents Scanned..............................: 5341
> - Extent Switches..............................: 5340
> - Avg. Pages per Extent........................: 6.8
> - Scan Density [Best Count:Actual Count].......: 84.48% [4512:5341]
> - Extent Scan Fragmentation ...................: 11.18%
> - Avg. Bytes Free per Page.....................: 843.4
> - Avg. Page Density (full).....................: 89.58%
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> After execution of DBCC DBREINDEX ('MF.dbo.Mytable')
>
> it is giving me same output as of above.
>
> I also tried DBCC indexdefrag but, of no use.
>
> Please help me.
>
>
> Thanks & Regards,
> Sajid C.
>
| |
| csajid@gmail.com 2006-10-28, 7:14 pm |
| Hi,
Thanks for your reply Tibor.
Now, what can i do to minimize the fragmentation.
Thanks & Regards,
Sajid C.
Tibor Karaszi wrote:[color=darkred
]
> You are looking at indexid 0. This means that the table doesn't have a clustered index, and you are
> looking at the data pages, for which there is no order between the pages. So, fragmentation doesn't
> apply for data pages in a heap.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> <csajid@gmail.com> wrote in message news:1161851618.291677.8560@i42g2000cwa.googlegroups.com...
| |
|
|
|
|
|
|
|