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...
What are the most common Windows 10 installation methods?
What will be an ideal response?
Which of the following is a standard for 802.11 networks? (Choose all that apply.)
A. 802.11a B. 802.11b C. 802.11c D. 802.11d
A navigation form is useful when you want to provide a ________ of options: navigation tabs and sub-navigation options
Fill in the blank(s) with correct word
Answer the following statements true (T) or false (F)
1. (x * 3) > = (x * x) when x = 3 2. (x * 3) > = (x * x) when x = 4 3. (x * 3) > = (x * x) when x = —2 4. (x * 3) < = (x * x) when x = 2 5. (x * 3) < = (x * x) when x = 3 6. 22 (x * 3) < = (x * x) when x = —1