What is an Index and its Types and Differences between them ?
What is an Index?
Indexing is a mechanism which makes record
fetching faster. It does this by having pre-sorted the rows of the table.
Types of Indexes:
- Clustered.
- Non-Clustered.
| Sno | Clustered | Non - Clustered |
| 1 | It reorders the physical storage of records in the table. | It sorts and maintain a separate storage. |
| 2 | There can be only one Clustered index per table. | More than one. |
| 3 | The leaf nodes contain data | The leaf node contains pointer to data |
0 comments
Post a Comment