Skip to Main Content
Forums

SQL & PL/SQL

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!

Query plan

632572Aug 18 2010 — edited Aug 18 2010
Hi,

is it possible to obtain query plan for delete operation on table with "on delete cascade"?

query plan for:
delete from table where ... returns cost = 1 which is not true

Internally 2001 rows is deleted with on delete cascade
table (1row delete) -> table2 (1000row delete) -> table3 (1000row delete)

in my opinion cost is more than 1

thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2010
Added on Aug 18 2010
2 comments
581 views