Database Administration (MOSC)

MOSC Banner

Delete takes too long

edited Jan 1, 2009 3:26AM in Database Administration (MOSC) 4 comments
 Hello,

I have a table of approx 100,000 rows.  I have 7 indexes on that table. I have unique key on the table of URI and a primary key on that value - all the other indexes are single column indexes on other columns.

The problem:

DELETE FROM MyTable WHERE ( uri = :"SYS_B_0" )

The above delete is taking between 30-40 seconds  - why?  I have accumlated the following things to look for, I would be grateful if you could add to the list:

1.    The execution plan did use the primary key (URI) but need to double-check.

2.    How should an index work in this case - look up the index value  -> rowid -> delete from table -> delete from primary key -> delete from other indexes - so maybe it is taking time in the indexes?  If so rebuild them all - they are not unique

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center