Indexing is a technique that optimizes data retrieval by minimizing disk access during database queries.
It enhances performance, allowing faster searches and efficient management of large datasets in databases.
Common types include Primary, Secondary, Clustered, and Non-Clustered indexes, each serving different purposes.
A primary index is built on a unique key, ensuring fast access to records by maintaining sorted order.
Dense indexing stores an index record for every search key, while sparse indexing stores records for some keys, saving space.
A clustering index organizes data based on non-key fields, optimizing retrieval for range queries and related data.
- Benefits of Indexing - Reduces query time significantly - Improves database performance - Enhances user experience