Manu
What is an Index?
By Manu in SQL Server on Jul 13 2006
  • Nik Nik
    Jan, 2018 16

    Index is a unique identifier of each data in a set or collection of data, starts from 0 to n Numbers. helps to access data faster

    • 0
  • siva
    Aug, 2006 3

    Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quicker.

    Indexes are of two types. Clustered indexes and non-clustered indexes. When you craete a clustered index on a table, all the rows in the table are stored in the order of the clustered index key. So, there can be only one clustered index per table.

    • 0
  • Manu
    Jul, 2006 13

    When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much faster when we have an index.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS