Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question What Are The Different Types Of Indexes?

Discussion in 'Database Management' started by krishatg, Mar 11, 2016.

  1. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    Indexing is a access strategy that allows to sort or search records in the table efficiently using the index column. In Indexing unique ROWID is assigned to each to row in a table.

    Types of Indexes:
    • UNIQUE INDEX: It does not allow the duplicate value in the index
    • SIMPLE INDEX: Index created on single column of the table.
    • COMPOSITE INDEX: Index created on more than 1 column of the table.
    • DUPLICATE INDEX.
     
  2. VIVEK KUMAR

    Yellow Belt

    Joined:
    Mar 8, 2016
    Messages:
    300
    Ratings:
    +2 / -0
    Indexing is used in the database for point out the data in the database easily. Ultimately with the help of index we can save lot of time Because index provide exact location of data in the database.
    Normally there are two types of indexing used in the database -
    • Primary index
    • Clustered index.
     
  3. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    A primary index is an ordered file whose record are fixed length with two fields.
    and in the cluster index, if record of file is physical ordered on non key field that does not have a unique value for each record.
     
  4. saurabh mathur

    Yellow Belt

    Joined:
    Nov 8, 2017
    Messages:
    130
    Ratings:
    +2 / -0
    The different types of indexes are:

    • Unique - Guarantees unique values for the column(or set of columns) included in the index
    • Covering - Includes all of the columns that are used in a particular query (or set of queries), allowing the database to use only the index and not actually have to look at the table data to retrieve the results
    • Clustered - This is way in which the actual data is ordered on the disk, which means if a query uses the clustered index for looking up the values, it does not have to take the additional step of looking up the actual table row for any data not included in the index.
    web hosting
     
  5. medyph

    White Belt

    Joined:
    Jan 26, 2018
    Messages:
    17
    Ratings:
    +0 / -0
    ndex type Description Additional information
    Clustered A clustered index sorts and stores the data rows of the t... Clustered and Nonclustered Indexes Described Create Clust...
    Nonclustered A nonclustered index can be defined on a table or view wi... Clustered and Nonclustered Indexes Described Create Noncl...
    Unique A unique index ensures that the index key contains no dup... Create Unique Indexes
    Columnstore An xVelocity memory optimized columnstore index based on ... Columnstore Indexes
     

Share This Page