<span>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.
I Think The Answer Is: Database index<span>. ... </span>Indexes<span> are used to quickly locate data without having to search every row in a </span>database <span>table every time a </span>database<span> table is accessed.</span>Indexes<span> can be created using one or more columns of a </span>database<span> table, providing the basis for both rapid random look ups and efficient access of ordered records.
