You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@sentry.apache.org by "Na Li (JIRA)" <ji...@apache.org> on 2018/04/23 18:48:00 UTC

[jira] [Created] (SENTRY-2211) Review the index creation for foreign keys

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)