What are the disadvantages of using an index?
What will be an ideal response?
First, an index occupies disk space. Using this space for an index, however, is technically unnecessary because any retrieval that you can make using an index can also be made without the index; the index just speeds up the retrieval.
The second disadvantage is that the DBMS must update the index whenever corresponding data in the database is updated.Without the index, the DBMS would not need to make these updates.
You might also like to view...
A transition in a movie appears once and that is right before the credits
Indicate whether the statement is true or false
The Insert Table of Figures button is located on the ________ tab in Word
Fill in the blank(s) with correct word
Windows _____ is a Microsoft closed source operating system
Fill in the blank(s) with correct word
Smart cards are an example of which of the following?
A. Something you know authentication B. Something you have authentication C. Something you are authentication D. All the above