Praveen Kumar
how many type of indexing in database?
By Praveen Kumar in ADO.NET on Jul 17 2009
  • Manoj Kumar
    Jan, 2017 3

    There are Two Types of Indexing present over , Clustered Index and Non-Clustered Index

    • 0
  • Purushottam Rathore
    Jul, 2009 24

    http://technet.microsoft.com/en-us/library/ms175049.aspx

    • 0
  • Naresh Kanth
    Jul, 2009 20

    There are five types of indexes: unique and non-unique indexes, and clustered and non-clustered indexes, and system generated block indexes for multidimensional clustered (MDC) tables .

    • 0
  • PEEYUSH MISHRA
    Jul, 2009 20

    A database Index is a data structure that improves the speed of operation on a database.

    Index  can be classified as clustered or non-clustered.

    1.Clustered Index

    1. The leaf level of a clustered index is the actual
      data
    2. the logical order of the index matches the physical stored
      order of the rows on disk.
    3. There can be only one Clustered index for a table.
    4. usually made on the primary key.

     2.Non-clustered Index

    1. the leaf level is actually a pointer to the data in rows
    2. the logical order of the index does not match the physical
      stored order of the rows on disk
    3. There can be only 249 Clustered index for a table
    4. usually made on the any key(Unique Key or any other)

    • 0
  • Praveen Kumar
    Jul, 2009 17

    thier are two type of indexing in dtabase cluster or noncluster indexing in database

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS