very poor performance of dropAll on Oracle

Description

When "dropAll" is performed against an Oracle database, the SQL used by UniqueConstraintSnaphotGenerator.listConstraints() has a cartesian join with the all_cons_columns table.

Patch attached.

Environment

Oracle 12c

Activity

Show:
Nathan Voxland
November 21, 2013, 4:13 PM

Applied patch, thanks!

Fixed

Reporter

Vadym Krevs

Components

Fix versions

Affects versions

Priority

Minor