Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1560

Join between global index and data table if INDEX hint used

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.3.0, 3.3.0
    • None
    • None

    Description

      We already have an INDEX hint, and we already have a mechanism to collect referenced columns in the data table that are not in the index table (used only for local indexes currently). Instead of not using the global index when a referenced data column is not found in the index, we should rewrite the query to join back to the data table when the INDEX hint is present. This is always possible, as we always have the data PK columns in the index table, and our join optimization would kick in as well.

      Attachments

        1. 1560.v3.patch
          59 kB
          Wei Xue
        2. 1560.v2.patch
          55 kB
          Wei Xue
        3. 1560.patch
          38 kB
          Wei Xue

        Activity

          People

            maryannxue Wei Xue
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: