Collections:
Creating an Index for Multiple Columns in SQL Server
How To Create an Index for Multiple Columns in SQL Server?
✍: FYIcenter.com
An index for multiple columns works similarly to a sorting process on multiple columns. If an index is defined for two columns, the index key is composed by values from those two columns.
A multi-column index will be used to speed up the search process based on the same columns in the same order as the index definition. For example, if you define an index called "combo_index" for "url" and "counts". "combo_index" will be used only when searching or sorting rows by "url" and "counts".
The tutorial exercise below shows you how to create an index for two columns:
-- Create an index for two columns CREATE INDEX combo_index ON fyi_links (url, counts); GO -- View indexes EXEC SP_HELP fyi_links; GO index_name index_description keys ----------------- -------------------------- ---- fyi_links_created nonclustered located on PRIMARY created fyi_links_url clustered located on PRIMARY url combo_index nonclustered located on PRIMARY url, counts -- Drop the index DROP INDEX fyi_links.combo_index; GO
⇒ Creating a Large Table with Random Data for Indexes in SQL Server
⇐ CREATE CLUSTERED INDEX - Adding Clustered Indexes in SQL Server
2016-11-13, 1436🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
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 I am new to Oracle database. Here is a list of f...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...