Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

When would you not add any indexes to a table?

When would you not add any indexes to a table?

Answers

KELVIN
(1)Do not index small tables. It may be more efficient to search the table in memory than to store an additional index structure.
(2)Avoid indexing a column or table that is frequently updated.
(3)Avoid indexing a column if the query will retrieve a significant proportion (for example, 25%) of the records in the table, even if the table is large. In this case, it may be more efficient to search the entire table than to search using an index.
(4)Avoid indexing columns that consist of long character strings.
kalvinspartan answered the question on July 4, 2018 at 17:11

Answer Attachments

Next: Having identified a column as a potential candidate, under what circumstances would you decide against indexing it?

Previous: Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.

View more Computer Science Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions