PREMIUM
🎯 PPSC Past Paper Test Series
30 Mock Tests (100 MCQs Each) + 3,000+ Past Paper MCQs
βœ… Detailed Explanations β€’ πŸ’‘ One-Liner Memory Hacks β€’ πŸ“š Previous Papers
WhatsApp 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

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

Join Our WhatsApp Channel ×
Scroll to Top