No Good...

Ran:

DECLARE @indid int

SELECT @indid = indid

FROM sysindexes

WHERE id = object_id('tablename')

AND name = 'indexname'

DBCC UPDATEUSAGE ('database', 'tablename', @indid)

GO

Results:

DBCC UPDATEUSAGE: sysindexes row updated...

RESULTS:

DBCC SHOWCONTIG For table: access_log_item

DBCC SHOWCONTIG scanning 'access_log_item' table...

Table: 'access_log_item' (1746105261); index ID: 0, database ID: 7

TABLE level scan performed.

- Pages Scanned................................: 302

- Extents Scanned..............................: 65

- Extent Switches..............................: 64

- Avg....

I was sure I did, I ran:

DBCC DBREINDEX (<TABLENAME>, '', <FILL_FACTOR>)

It was my understanding that by putting the '' (Placeholder)into the spot where you specify the index, it would include...

DBCC DBREINDEX right? I tried that and then ran:

DECLARE @idINT

SELECT @id = object_id('tablename')

DBCC SHOWCONTIG(@id)

GO

But the DBCC DBREINDEX command does not defragment. The fragmentation still exists. Any ideas?

EnoSonic

What is the command for SQL 7.0 to defrag the indexes?

EnoSonic