SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Understanding Index ID
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbates99
Constraint Violating Yak Guru

381 Posts

Posted - 02/03/2014 :  11:17:47  Show Profile  Reply with Quote
As you see below, this index has severe fragmentation.
This table has a PK as well as a few regular indexes.

Is Index ID 0 always the Primary Key? Is there a way of determining exactly which index the ID # relates to?
Thanks, Jack

index ID: 0, database ID: 8
TABLE level scan performed.
- Pages Scanned................................: 65904
- Extents Scanned..............................: 8386
- Extent Switches..............................: 8385
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 98.24% [8238:8386]
- Extent Scan Fragmentation ...................: 71.54%
- Avg. Bytes Free per Page.....................: 208.6
- Avg. Page Density (full).....................: 97.42%

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 02/03/2014 :  12:13:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
Index_id=0 is a heap: http://technet.microsoft.com/en-us/library/ms173760.aspx

Use object_id, name to determine which index it is.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000