PREMIUM
๐ŸŽฏ PPSC Deputy Accountant Premium Preparation
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

Join Our WhatsApp Channel ×
Scroll to Top