[ https://issues.apache.org/jira/browse/SENTRY-2211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Na Li reassigned SENTRY-2211: ----------------------------- Assignee: (was: Na Li) > Review the index creation for foreign keys > ------------------------------------------ > > Key: SENTRY-2211 > URL: https://issues.apache.org/jira/browse/SENTRY-2211 > Project: Sentry > Issue Type: Task > Components: Sentry > Affects Versions: 2.1.0 > Reporter: Na Li > Priority: Major > > 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)