PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

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.

0 comments

Leave a Reply

Join Our WhatsApp Channel ×