Description
AUTHZ_PATH does not have index on the foreign key AUTHZ_OBJ_ID. When the number of entries become really large, a command like "select * from AUTHZ_PATH where AUTHZ_OBJ_ID = 8311512" becomes very slow because it results in table scan.
To improve performance, we should add index for its foreign key in table AUTHZ_PATH.
The sql script to do this in Oracle is "CREATE INDEX AUTHZ_PATH_FK_IDX on AUTHZ_PATH(AUTHZ_OBJ_ID);"
Attachments
Attachments
Issue Links
- links to