Index Structures

Question

Post reply

Index Structures

WayneS

SSC Guru

Points: 95460
More actions
May 20, 2010 at 10:01 pm

#222839

Comments posted to this topic are about the item Index Structures
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 15 posts - 1 through 15 (of 46 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Why is the correct answer 4?

I count 7 types of indexes:

clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.

See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.

Even in the explanation given I count more than 4.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

tommyh SSCertifiable Points: 6302 More actions · Answer 2

da-zero (5/20/2010)
Why is the correct answer 4?
I count 7 types of indexes:
clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.
See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.
Even in the explanation given I count more than 4.

Question about types of index structures... not index types. So snagging abit from the end off each line give us:

B-Tree structure

token-based functional index

internal table(aka nodes table)

B+-Tree

AK_K Right there with Babe Points: 791 More actions · Answer 3

the question is abot types of index structures but not about the types of indexes.

[font="Times New Roman"]Anil Kubireddi[/font]

Chris Houghton SSCrazy Points: 2557 More actions · Answer 4

This question is open to ambiguity IMO. I went for 3 - Heap, clustered and non-clustered.

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

Arjun SreeVastsva SSCertifiable Points: 7141 More actions · Answer 5

This Question is Based on Index Structures

Spatial and Filtered indexes have a B-Tree structure.

Full-text indexes have a token-based functional index.

XML Primary indexes have an internal table(aka nodes table).

XML Secondary indexes have a B+-Tree index structure

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

tommyh (5/21/2010)
da-zero (5/20/2010)
Why is the correct answer 4?
I count 7 types of indexes:
clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.
See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.
Even in the explanation given I count more than 4.
Question about types of index structures... not index types. So snagging abit from the end off each line give us:
B-Tree structure
token-based functional index
internal table(aka nodes table)
B+-Tree

Aaaaaaah. That explains 😀

Why do I answer those questions so early in the morning?

But, to nitpick a bit, the explanation isn't very clear. I have read it multiple times and it's hard (for me) to find the 4 distinct types of index structures.

Or maybe it is just friday...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bob JH Cullen SSCrazy Points: 2082 More actions · Answer 7

I feel the need to enter the confessional - I got it right but for completely the wrong reason:Whistling: Where can I return my 2 points?

I, too, was confused between index types and structures, and then couldn't think of more than 4 (Clustered, Non-clustered, Full text and XML were my answers).

I'll blame it on Friday, too 😉 But, hey! the sun is shining here in South Cambridgeshire, so who cares?

vk-kirov SSCertifiable Points: 7686 More actions · Answer 8

WayneS (5/20/2010)
XML Secondary indexes have a B+-Tree index structure.
XML Secondary Indexes: http://msdn.microsoft.com/en-us/library/bb522562.aspx

I couldn't find a reference to B+ trees on that BOL page.

Where can I read about secondary XML index structure?

atikdesai Mr or Mrs. 500 Points: 517 More actions · Answer 9

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

honza.mf SSCertifiable Points: 5519 More actions · Answer 10

I guessed right. Great aid for me was the gaps between neumbers. If the row of numbers was complete...

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 11

Daniel Bowlin

SSC-Dedicated

Points: 34566

May 21, 2010 at 7:14 am

#1170796

Structures and Types. Argh!

matthew.pullen SSChasing Mays Points: 644 More actions · Answer 12

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!

sburcombe SSCrazy Points: 2460 More actions · Answer 13

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

S

Simone

johnf_amic Mr or Mrs. 500 Points: 532 More actions · Answer 14

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.