SQL Server tutorial part 4 - Index
Indexes are used in SQL server to quickly retrieve the information
Type of Indexes
In SQL Server indexes are one of the following two types:- Clustered Index
- Non-Clustered Index.
- Clustered Index
A clustered index is the index that will arrange the rows physically in the memory in sorted order. An advantage of a clustered index is that searching for a range of values will be fast.
- Non-clustered Index
A non-clustered index is an index that will not arrange the rows physically in the memory in sorted order. An advantage of a non-clustered index is searching for the values that are in a range will be fast. You can create a maximum of 999 non-clustered indexes on a tableSample Table
Create index
Create index
Drop index
Please donate and support at https://www.paypal.me/Rajcoomar
Comments
Post a Comment