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, 2566🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...