PREMIUM
πŸ“š FPSC SST 2026 Preparation Group
Join Our WhatsApp Group for SST Past Papers & Mock Tests
βœ… Daily MCQs β€’ πŸ’‘ Expert Tips β€’ πŸ“š Past Paper Discussion
Join Group β†’

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

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top