It is usually a bad idea to create indexes on every attribute because Marks: MSQ
a) Every index requires additional CPU time and disk I/O overhead during inserts and dele-
tions
b) Indexes on non-primary keys might have to be changed on updates, although an index on
the primary key might not
c) If there are n attributes, then 2^n indexes would be needed which is exponential
d) Each extra index requires additional storage space
Answers
Answered by
0
d is the correct ans because we create index to perform some operation according to sorting of data
Goldensingh123:
Option a. Should also b the right answer
exactly its a) and as well as d)
hey ppl we create index of already existing data no insertion and delete operations will be performed
Answered by
1
The answers are Options d), b) and a).
It is usually a bad idea to create indexes on every attribute because
*Each extra index requires additional storage space.
*Indexes on non-primary keys might have to be changed on updates, although an index on the primary key might not.
*Every index requires additional CPU time and disk I/O overhead during inserts and deletions.
Similar questions