Question
What is indexing in a Database Management System (DBMS)?
Asked by: USER9317
56 Viewed
56 Answers
Answer (56)
Indexing in a DBMS is a technique used to speed up data retrieval operations on database tables. It's like an index in a book – it allows the database to quickly locate specific rows without having to scan the entire table. An index is a separate data structure (typically a B-tree) that contains a sorted list of values from one or more columns in a table, along with pointers to the corresponding rows.