What are the disadvantages of adding indexes to a database table?
The database is a way to store the data in a tabular form so we can access it easily. For making a database we use some tools like SQL, MYSQL, MS-ACCESS, ORACLE, etc. They are using their own languages to manipulate the data.
Answer and Explanation: 1
The indexing is to add one more unique column with respect to the columns.
The disadvantage of the Indexing is:
. It takes more space on the disk.
. It reduces the performance of the DELETE, Inserts, Updates because At the execution of the query the index will also be updated, inserted,
deleted and it takes a time.
. Some database tools have rules for making this like if the indexes are really much needed then only it is created.
Become a member and unlock all Study Answers
Try it risk-free for 30 daysTry it risk-free
Ask a question
Our experts can answer your tough homework and study questions.Ask a question Ask a question
Learn more about this topic:
fromChapter 11 / Lesson 12
In this lesson, we'll be looking at databases, which are computer mechanisms for storing and retrieving data. Test your knowledge following the lesson with a quiz.