Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Index Structures Expand / Collapse
Author
Message
Posted Friday, May 21, 2010 6:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:47 PM
Points: 1,298, Visits: 1,306
I guessed right. Great aid for me was the gaps between neumbers. If the row of numbers was complete...



See, understand, learn, try, use efficient
© Dr.Plch
Post #925905
Posted Friday, May 21, 2010 7:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
Structures and Types. Argh!
Post #925927
Posted Friday, May 21, 2010 7:32 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 8:07 AM
Points: 462, Visits: 119
Shazbuts!!!

I also went for types but could only think of 3 off the top of my head... (Bad DBA, no donuts for you)

Clustered, Non Clustered & XML.

...Hangs head in shame!
Post #925937
Posted Friday, May 21, 2010 8:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:41 PM
Points: 1,970, Visits: 276
Good question! It fooled me too; I also went for types. But it woke me up!

S


Simone
Post #926003
Posted Friday, May 21, 2010 9:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 07, 2014 9:24 AM
Points: 368, Visits: 258
My problem is, I couldn't find a clear definition of "Index Structure". It seems to be a loosely-defined term. It's hard to count something I can't define.

Can anyone give a defintion, explanation, or a pointer to more information? Thanks.
Post #926051
Posted Friday, May 21, 2010 9:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 10, 2014 3:52 PM
Points: 1,380, Visits: 2,681
honza.mf (5/21/2010)
I guessed right. Great aid for me was the gaps between neumbers. If the row of numbers was complete...


I got it right because of the gap as well also because I counted 4. The 4 I counted were wrong but close. My guess on the structure was clustered, non-clustered, XML and spatial. As I write this I remember that I did know that clusterd and non-clustered indexes share the same structure. What I didn't know was about the structure of XML secondary.


---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #926057
Posted Friday, May 21, 2010 9:56 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 20,467, Visits: 14,105
Excellent question Wayne.

Thanks




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #926073
Posted Friday, May 21, 2010 11:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 6,545, Visits: 8,763
About 3 weeks ago, I was doing some research on a related topic and found that this answer is wrong. I had asked Steve to change this question then.

This QotD should be:
Correct Answer: 3
Explanation: Index types Clustered, Non-clustered, Unique, Non-Clustered with Included columns, Indexed Views, Spatial and Filtered indexes have a B-Tree index structure.
Full-text indexes have a token-based functional index with an inverted, stacked, compressed index structure.
XML Indexes (Primary and Secondary) have a B+-Tree index structure.

References:
Clustered Index Structures: http://msdn.microsoft.com/en-us/library/ms177443.aspx
Non-Clustered Index Structures:http://msdn.microsoft.com/en-us/library/ms177484.aspx
XML Primary Indexes:http://msdn.microsoft.com/en-us/library/ms345121(SQL.90).aspx
XML Secondary Indexes:http://msdn.microsoft.com/en-US/library/ms187508(v=SQL.90).aspx
Spatial Indexes: http://msdn.microsoft.com/en-us/library/bb964712.aspx
Full-Text Indexes: http://technet.microsoft.com/en-us/library/cc879306.aspx
Unique, Filtered, Indexed Views and Indexes with included columns: http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.100).aspx

B-Tree index structures: http://en.wikipedia.org/wiki/B_tree_Indexing
B+-Tree index structures: http://en.wikipedia.org/wiki/B%2B_tree

I'm very sorry for the confusion. I'll get with Steve to see what can be done to get this resolved.

Edit: fixed links to work correctly


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #926150
Posted Friday, May 21, 2010 11:23 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 12:55 AM
Points: 771, Visits: 504
Great question. I learned something new.
Post #926152
Posted Friday, May 21, 2010 1:25 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 12:10 PM
Points: 3,766, Visits: 3,584
atikdesai (5/21/2010)
I count 9.
Clustered, Nonclustered, Unique, Index with included columns, Indexed views, Full-text , Spatial, Filtered, XML

http://msdn.microsoft.com/en-us/library/ms175049.aspx


I agree, this was my count also. I guess some of these different index types could have the same structure?
Post #926244
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse