Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-1931 (Umbrella) Add more Query Rewriting Rules
  3. TAJO-1688

Support change of multiple ORs in WHERE clause with RHS constant val

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Planner/Optimizer
    • None

    Description

      (col1=val1 OR col1=val2 OR col1=val3) where val1,val2,val3 are constants can be converted to col1 IN (val1, val2, val3) for better performance.

      Attachments

        Activity

          People

            atris Atri Sharma
            atris Atri Sharma
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: