Index Structures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » Index Structures

47 posts, Page 2 of 5

««1 2 3 4 5 »»»

Index Structures

Rate Topic

Display Mode

Topic Options

Author

Message

honza.mf

Posted Friday, May 21, 2010 6:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:11 AM
Points: 1,114, Visits: 1,209

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

Daniel Bowlin

Posted Friday, May 21, 2010 7:14 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 2,681, Visits: 2,423

Structures and Types. Argh!

Post #925927

matthew.pullen

Posted Friday, May 21, 2010 7:32 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 27, 2013 8:14 AM
Points: 462, Visits: 102

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

sburcombe

Posted Friday, May 21, 2010 8:24 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, June 14, 2013 11:03 AM
Points: 1,639, Visits: 256

Good question! It fooled me too; I also went for types. But it woke me up!

S

Simone

Post #926003

johnf_amic

Posted Friday, May 21, 2010 9:14 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 6:41 AM
Points: 352, Visits: 244

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

Trey Staker

Posted Friday, May 21, 2010 9:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 1,380, Visits: 2,636

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

SQLRNNR

Posted Friday, May 21, 2010 9:56 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

Excellent question Wayne.

Thanks

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

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

WayneS

Posted Friday, May 21, 2010 11:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:13 PM
Points: 6,386, Visits: 8,286

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

KevinC.

Posted Friday, May 21, 2010 11:23 AM

Right 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

Cliff Jones

Posted Friday, May 21, 2010 1:25 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:31 PM
Points: 3,418, Visits: 3,438

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 »

47 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions