234k views
1 vote
What is a database index?

2 Answers

3 votes
Index Structures are created on columns in tables or views. ... For example, if you create an indexon the primary key and then search for a row of data based on one of the primary key values, SQL Server first finds that value in the index, and then uses the index to quickly locate the entire row of data.

Thses are NOT my words, just so you know
User Ryan Olson
by
5.9k points
2 votes
I Think The Answer Is: Database index. ... Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed.Indexes can be created using one or more columns of a database table, providing the basis for both rapid random look ups and efficient access of ordered records.

Hope This Helped!
User Rodedo
by
6.1k points