sentry-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Na Li (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SENTRY-2211) Review the index creation for foreign keys
Date Mon, 23 Apr 2018 18:48:00 GMT
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)

Mime
View raw message