Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Impact of index updation on the performance os business flow
gvr
post May 12 2017, 08:08 AM
Post #1


Newbie
*

Group: Members
Posts: 2
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?


Go to the top of the page
 
+Quote Post
burleson
post May 14 2017, 04:31 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,491
Joined: 26-January 04
Member No.: 13



Hi gvr, and welcome to the forum!

>> Does this 100ms include the time that oracle spent on maintaining indexes of the table?

The time spent in the database should include the index update time!






--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
gvr
post May 15 2017, 12:52 AM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 12-May 17
Member No.: 51,976



Thanks Burleson.

QUOTE (burleson @ May 14 2017, 04:31 PM) *
Hi gvr, and welcome to the forum!

>> Does this 100ms include the time that oracle spent on maintaining indexes of the table?

The time spent in the database should include the index update time!

Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 21st August 2017 - 01:31 AM