Re: how do you know indexes have been fragmented

Hi, try "oncheck -pT <database:tablename>". I'm sure there's a cool way by querying system catalog or sysmaster database, but that I don't know from top of my head ... Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 01.02.2005 15:50:21: > i ran dbcc showcontig on my sql server db and it returned following > > 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 Extent 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 fragmented. > > If indexes are really fragmented what is the best way without > reindexing(or is that the best way) to defrag the indexes. > Thank you > Kalpesh > sending to informix-list