You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Sergio Peña (JIRA)" <ji...@apache.org> on 2018/04/25 20:22:00 UTC
[jira] [Commented] (SENTRY-2211) Review the index creation for
foreign keys
[ https://issues.apache.org/jira/browse/SENTRY-2211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16453026#comment-16453026 ]
Sergio Peña commented on SENTRY-2211:
-------------------------------------
It this an improvement or just a task to review? I feel this is just a task that may find new improvements for indexes.
> 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
> 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)