|
Answer» The following are the advantages of indexing in DBMS: - It allows you to reduce the total number of I/O operations required to retrieve that data by eliminating the necessity to ACCESS a database entry through an index structure.
- Users may search and retrieve info more quickly.
- You can save tablespace by indexing because you don't need to CONNECT to a row in a table because the ROWID isn't stored in the index. As a result, you will be able to save table space.
The following are the disadvantages of indexing in the context of DBMS: - Partitioning an index-organized table is not permitted.
- Indexing in SQL reduces the speed of INSERT, DELETE, and UPDATE QUERIES.
|