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 |
|
artur
Starting Member
3 Posts |
 Posted - 2004-03-12 : 11:49:01
|
| Hi,Can anyone explain this to me? I have run DBCC SHOWCONTIG on over 30 tables. They don’t look great but my question is about this line:Table: 'CONTENT_TEXT' (1977058079); index ID: 255, database ID: 7I am wondering what is the index ID: 255? I could not find any help on the Internet explaining about index ID: 255 and why I got it.I know that the database used to be ORACLE 8.0 and it was moved last summer into SQL SEVER 2000. Would transfer create this INDEX?Here is the whole statement:DBCC SHOWCONTIG scanning 'CONTENT_TEXT' table...Table: 'CONTENT_TEXT' (1977058079); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 517- Extents Scanned..............................: 74- Extent Switches..............................: 454- Avg. Pages per Extent........................: 7.0- Scan Density [Best Count:Actual Count].......: 14.29% [65:455]- Logical Scan Fragmentation ..................: 47.00%- Extent Scan Fragmentation ...................: 66.22%- Avg. Bytes Free per Page.....................: 2805.6- Avg. Page Density (full).....................: 65.34%DBCC SHOWCONTIG scanning 'CONTENT_TEXT' table...Table: 'CONTENT_TEXT' (1977058079); index ID: 255, database ID: 7LEAF level scan performed.- Pages Scanned................................: 14462- Extents Scanned..............................: 1816- Extent Switches..............................: 1815- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 99.56% [1808:1816]- Extent Scan Fragmentation ...................: 16.52%- Avg. Bytes Free per Page.....................: 457.4- Avg. Page Density (full).....................: 94.35%DBCC execution completed. If DBCC printed error messages, contact your system administrator.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-12 : 12:31:53
|
| From sysindexes topic in SQL Server Books Online:ID of index: 1 = Clustered index>1 = Nonclustered255 = Entry for tables that have text or image dataTara |
 |
|
|
artur
Starting Member
3 Posts |
Posted - 2004-03-12 : 12:39:48
|
Hi Tara, Yes these 3 tables have text/image data fields in them.So I quess this is OK to show Index ID: 255/Thanks |
|
|
|
diamond
Starting Member
2 Posts |
Posted - 2004-03-12 : 15:38:28
|
| Your table 'CONTENT_TEXT' which appear to have a clustered index is badly fragmented as scan density is too low and logical fragmentation is too high for index id 1. Your queries will run slow as there is no obvious indexes.Try this dbcc dbreindex( table name)This will however lock your table. So try this when traffic to this table is low, in night or week ends. Hope this helps.Diamond |
|
|
|
artur
Starting Member
3 Posts |
Posted - 2004-03-12 : 16:17:57
|
| Hi Diamond,Thanks for reply even I knew what I have to do with the DBCC DBREINDEX. But my question was about Table: 'CONTENT_TEXT' (1977058079); index ID: 255, database ID: 7I wasn't sure why I was getting this strange index ID: 255. I think Tara was able to help me. But thanks anyway.Artur |
|
|
|
|
|
|
DBCC SHOWCONTIG - index ID: 255?