InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 19:25:59 GMT20http://www.sqlservercentral.com/Forums/Topic618862-5-1.aspxAs per books online:Logical Scan Fragmentation Percentage of out-of-order pages returned from scanning the leaf pages of an index. This number is not relevant to heaps and text indexes. Extent Scan Fragmentation Percentage of out-of-order extents in scanning the leaf pages of an index. This number is not relevant to heaps. You should not consider these numbers for heaps. In the sheet attached by you this can be easily depicted.MJMon, 15 Dec 2008 04:08:08 GMTMANU-J.http://www.sqlservercentral.com/Forums/Topic618862-5-1.aspxDBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXESFri, 12 Dec 2008 18:40:22 GMTJpotucekhttp://www.sqlservercentral.com/Forums/Topic618862-5-1.aspxThanks! I did a DBREINDEX on all tables in my DB (individually) using this format: use MYDBDBCC DBREINDEX ('MYDB.Territories', '', 70)After doing this, the logical fragmentation and extent fragmentation numbers are still VERY high.. like 98 and 99%????Fri, 12 Dec 2008 13:32:55 GMTJpotucekhttp://www.sqlservercentral.com/Forums/Topic618862-5-1.aspxrebuild indexes.Fri, 12 Dec 2008 12:18:47 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic618862-5-1.aspxIf I run DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES against my SQL Server 2000 database and see High Extent Fragmentation and logical Fragmentation numbers, what is the recommended way to remedy this??Fri, 12 Dec 2008 12:13:35 GMTJpotucek