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 Thursday, May 20, 2010 10:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:59 PM
Points: 5,357, Visits: 8,912
Comments posted to this topic are about the item Index Structures

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 #925652
Posted Thursday, May 20, 2010 11:54 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #925686
Posted Friday, May 21, 2010 1:03 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Sunday, June 29, 2014 11:26 PM
Points: 1,481, Visits: 1,960
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
Post #925704
Posted Friday, May 21, 2010 1:04 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, April 10, 2014 9:41 AM
Points: 695, Visits: 264
the question is abot types of index structures but not about the types of indexes.

Anil Kubireddi
Post #925705
Posted Friday, May 21, 2010 1:09 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 5, 2014 7:57 AM
Points: 558, Visits: 1,481
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

Post #925712
Posted Friday, May 21, 2010 1:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:47 AM
Points: 2,296, Visits: 1,427
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
Post #925713
Posted Friday, May 21, 2010 1:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
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...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #925724
Posted Friday, May 21, 2010 3:01 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 6:59 AM
Points: 641, Visits: 495
I feel the need to enter the confessional - I got it right but for completely the wrong reason 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?
Post #925763
Posted Friday, May 21, 2010 3:47 AM
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: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
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?
Post #925790
Posted Friday, May 21, 2010 5:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 24, 2011 11:30 PM
Points: 17, Visits: 50
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
Post #925840
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse