[
https://issues.apache.org/jira/browse/SENTRY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Na Li updated SENTRY-2219:
--------------------------
Summary: Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH only when it
does not exist for Oracle (was: Create index AUTHZ_PATH_FK_IDX at table
AUTHZ_PATH only when it does not exist)
> Create index AUTHZ_PATH_FK_IDX at table AUTHZ_PATH only when it does not
> exist for Oracle
> -----------------------------------------------------------------------------------------
>
> Key: SENTRY-2219
> URL: https://issues.apache.org/jira/browse/SENTRY-2219
> Project: Sentry
> Issue Type: Improvement
> Components: Sentry
> Affects Versions: 2.1.0
> Reporter: Na Li
> Assignee: Na Li
> Priority: Major
> Attachments: SENTRY-2219.001.patch
>
>
> Adding this index AUTHZ_PATH_FK_IDX in Oracle improves performance
> significantly, therefore some user may have added this index manually. To
> avoid exception when running upgrade sql script, we should add this index
> only when it does not exist.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)