Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » Index Structures
Add to briefcase
47 posts, Page 1 of 5
12345»»»

Index Structures Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
WayneS
Posted Thursday, May 20, 2010 10:01 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 6,367, Visits: 8,227
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
Koen Verbeeck
Posted Thursday, May 20, 2010 11:54 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 9,366, Visits: 6,463
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
tommyh
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: Friday, May 10, 2013 3:15 AM
Points: 1,476, Visits: 1,943
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
Anil KK
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: 2 days ago @ 5:00 AM
Points: 662, Visits: 239
the question is abot types of index structures but not about the types of indexes.

Anil Kubireddi
Post #925705
Chris Houghton
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: Thursday, May 16, 2013 9:12 AM
Points: 557, Visits: 1,356
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
Sree Arjun Div
Posted Friday, May 21, 2010 1:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173, Visits: 1,350
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
Koen Verbeeck
Posted Friday, May 21, 2010 1:39 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 9,366, Visits: 6,463
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
Bob Cullen-434885
Posted Friday, May 21, 2010 3:01 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: Wednesday, May 15, 2013 5:10 AM
Points: 507, Visits: 384
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
vk-kirov
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: 2 days ago @ 1:32 AM
Points: 3,187, Visits: 4,140
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
atikdesai
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
47 posts, Page 1 of 5
12345»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.