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


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