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

Status

Reporter

Vadym Krevs

Components

Fix versions

Affects versions

Priority

Minor
Configure