Enhancement request: modify a system-required index

Currently, Toad doesn’t allow an index used by a primary key constraint to be modified. I’d like to be able to change things like clustering, %free, allow reverse scans on a PK index. Toad would need to drop the PK constraint, drop the index, rebuild the index with changes, and re-add the PK.

Jim Frentress
Principal Financial Group

Hello Jim,

I have opened enhancement request 73,390 for you regarding your suggestion for
Toad for DB2 functionality.