InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Do I Need To Consider When I Create New Indexes? |
|
Answer» Indexes are additional DATA structures that must be maintained with each CHANGE to the table data. Therefore, the effort involved in a data change (INSERT, UPDATE, DELETE) in the database increases with the NUMBER of indexes in a table. You should therefore ensure that the indexes you CREATE in the customer namespace are actually used by the APPLICATION also. Indexes are additional data structures that must be maintained with each change to the table data. Therefore, the effort involved in a data change (INSERT, UPDATE, DELETE) in the database increases with the number of indexes in a table. You should therefore ensure that the indexes you create in the customer namespace are actually used by the application also. |
|