Index Structures

  • 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

  • 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

  • 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

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

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

  • 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

  • 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

  • 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

  • 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?

  • 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?

  • 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 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

  • Structures and Types. Argh!

  • 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!

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

    S

    Simone
  • 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.

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

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