Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18413

Find constraint correlated indexes

    XMLWordPrintable

Details

    Description

      This task concern constraints on one table only.

      Two indexes i1 and i2 are called constraint correlated if some of their parts are contained in the same constraint.

      For example:
      Consider table lineitem from dbt3 benchmark.

      Index i1: on lineitem(l_shipdate)
      Index i2: on lineitem(l_receiptdate)

      And let's add constraint c on lineitem: l_shipdate < l_receiptdate
      (can be easily checked that it is true for the lineitem table)

      As i1 l_shipdate and i2 l_receiptdate both participate in c, indexes i1 and i2 are constraint correlated.

      Attachments

        Activity

          People

            shagalla Galina Shalygina (Inactive)
            shagalla Galina Shalygina (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.