Ad
Sponsored by Sir Tauqeer
CLICK HERE TO JOIN SIR TAUQUEER WHATSAPP GROUP
FOR PREPARATION CLASSES AND JOBS UPDATES
Join Now

What is the purpose of indexing?

A. To reduce table size
B. To speedup data search
C. Both A & B
D. None of the above
Correct Answer: B. To speedup data search

The primary purpose of indexing in databases is to speed up data search and retrieval operations. An index is a special lookup table that the database search engine can use to quickly find data. Much like an index in a book, it points to the location of specific data records without having to scan the entire table, significantly reducing query execution time for large datasets.

Leave a Comment

Join Our WhatsApp Channel ×
Scroll to Top