Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete Performance on Index Organised Tables

710101Jul 3 2009 — edited Jun 5 2012

Hello,

We are having a few performance problems with one of our tables.

We have a table (test) which has 9 columns:

A number(10) not null pk,
B number(10),
C number(10),
D number(10),
E number(10),
F varchar2(30),
F varchar2(2),
G varchar2(2),
H varchar2(250),

The table test is an IOT (Index Organised Table) in default IOT configuration.
All of the columns are frequently required so we cannot overflow any.

The table currently has 8m records, which is roughly 1/2 a years worth of data, so not significant.
Inserts and updates are fine, but deleting a single row is taking 40+ seconds!

(delete from test where a = 3043;)

If I convert this table in to a standard table, deletes are only 0.5 of a second?!

Any idea why the delete statement takes an inordinately long time on the IOT, or what I might be doing wrong?

Thanks
Victoria

Oracle Enterprise version 10.2.0.1.0
Oracle XE version 10.2.0.1.0

This post has been answered by Richard Foote on Jul 3 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2012

Added on Jul 3 2009

#general-database-discussions

15 comments

5,034 views