Delete takes too long
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:
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