Collections:
What Are Indexes in SQL Server
What Are Indexes in SQL Server?
✍: FYIcenter.com
An index is a secondary database object associated with a table to improve the retrieval performance of rows from that table.
An index can be defined for a single column or multiple columns of a given table. If an index is defined on a single column of a table, the index can be viewed as ordered map between all values in that column and their row locations in the table. For examples, if you have table with a column called "company_num" and you created an index for that column. The contents of the table and the index may look like what is presented in the following picture:
As shown in the above picture, locating the rows of company_num = 17 can be done much faster through the index.
⇒ CREATE INDEX - Adding an Index on an Existing Table in SQL Server
⇐ Understanding and Managing Indexes in SQL Server
2016-11-15, 4572🔥, 0💬
Popular Posts:
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...