Indexing improves database search performance by creating a structure that allows quick data retrieval.
Total Questions
3
Display Order
#30
Category
Databases
An index is a data structure that improves the speed of data retrieval operations.
Common types include B-Tree indexes, Hash indexes, and Full-text indexes.
They speed up queries by reducing the number of rows scanned.