Na Li created SENTRY-2211:
-----------------------------
Summary: Review the index creation for foreign keys
Key: SENTRY-2211
URL: https://issues.apache.org/jira/browse/SENTRY-2211
Project: Sentry
Issue Type: Improvement
Components: Sentry
Affects Versions: 2.1.0
Reporter: Na Li
Assignee: Na Li
It is generally recommended to create an index which leads on the foreign key
column(s), to support not only joins between the primary and foreign keys, but
also updates and deletes.
We should review the foreign keys and check if there is an index defined, if
not, should we create index.
More details on The Benefits of Indexing Foreign Keys
https://sqlperformance.com/2012/11/t-sql-queries/benefits-indexing-foreign-keys
Indexes on foreign keys
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:292016138754
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
