1. I've started a massive SPAM purge, any accounts that have spammed are being removed, also for a short period new user signups are disallowed until the SPAM cleaning is finished.

What is index architecture?????

Discussion in 'Databases' started by sanamgupta, Mar 14, 2015.

  1. sanamgupta

    sanamgupta New Member

    Joined:
    Nov 7, 2014
    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    3
    Gender:
    Female
    In database, index architectures can be classified as clustered or non-clustered.
    Non-clustered:
    A non-clustered index is structured in a way that doesn't correspond to the order of the actual data records. It resembles the words index at the back of a book. For this reason, it will perform worse than clustered indexes on ranged searches where the result set is large, since each result could an additional I/O operations to get the actual data record.
    Clustered:
    Clustering re-orders the data block in the same order as the index, hence it is also an operation on the data storage blocks as well as on the index. A phone book ordered by last name resemples a clustered index in it structure and purpose.
    Loading...

Share This Page