Joined: 12-May 17
Member No.: 51,976
I have a table having 1M rows. I have few business flows which insert/update/query this table. It has indexes on the columns as needed. I understand from oracle documentation that "The database automatically maintains indexes when you insert, update, and delete rows of the associated table."
My questions is around index updation during insert operations on this table. When a business flow is run, a row is inserted in this table. Let us say it took 800ms for this flow and it spent 100ms in the database. Does this 100ms include the time that oracle spent on maintaining indexes of the table? Or does oracle maintain the indexes asynchronously when new rows are inserted in a table?