kalpesh.s...@gmail.com Feb 1, 6:50 am show options
Newsgroups: comp.databases.informix
From: kalpesh.s...@gmail.com - Find messages by this author
Date: 1 Feb 2005 06:50:21 -0800
Local: Tues, Feb 1 2005 6:50 am
Subject: how do you know indexes have been fragmented
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
i ran dbcc showcontig on my sql server db and it returned fo*llowing
Table: 'Table1' (1621580815); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 4982
- Extents Scanned..............................: 628
- Extent Switches..............................: 627
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 99.20% [623*:628]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 99.52%
- Avg. Bytes Free per Page.....................: 38.3
- Avg. Page Density (full).....................: 99.53%
Based on searching for info on index defrag it seems my Exte*nt Scan
Fragmentation percentage is not what it should be (0%) . Is *it true
and
if yes how can you be sure that your indexes have been fragm*ented.
If indexes are really fragmented what is the best way withou*t
reindexing(or is that the best way) to defrag the indexes.
Thank you
Kalpesh