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

Full table scan performed for DELETE with table having immutable indexes

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.13.0
    • Component/s: None
    • Labels:

      Description

      If a DELETE command is issued with a partial match for the leading part of the primary key, instead of using the data table, when the table has immutable indexes, a full scan will occur against the index.

        Attachments

        1. PHOENIX-4290_wip9.patch
          95 kB
          James R. Taylor
        2. PHOENIX-4290_wip8.patch
          95 kB
          James R. Taylor
        3. PHOENIX-4290_wip7.patch
          89 kB
          James R. Taylor
        4. PHOENIX-4290_wip6.patch
          85 kB
          James R. Taylor
        5. PHOENIX-4290_wip5.patch
          78 kB
          James R. Taylor
        6. PHOENIX-4290_wip4.patch
          72 kB
          James R. Taylor
        7. PHOENIX-4290_wip3.patch
          72 kB
          James R. Taylor
        8. PHOENIX-4290_wip2.patch
          56 kB
          James R. Taylor
        9. PHOENIX-4290_wip10.patch
          95 kB
          James R. Taylor
        10. PHOENIX-4290_wip1.patch
          57 kB
          James R. Taylor
        11. PHOENIX-4290_v3.patch
          103 kB
          James R. Taylor
        12. PHOENIX-4290_v2.patch
          103 kB
          James R. Taylor
        13. PHOENIX-4290_v1.patch
          102 kB
          James R. Taylor

          Activity

            People

            • Assignee:
              jamestaylor James R. Taylor
              Reporter:
              jamestaylor James R. Taylor
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: