Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-22143

Index scans for OR predicates on disjoint terms

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 4.5.1, 4.6.0
    • query
    • None

    Description

      The following currently uses a primary scan. It can instead use an OR scan over two indexes.

      CREATE INDEX idx_a ON default( a );
      		 
       
      		 
      CREATE INDEX idx_b ON default( b );
      		 
       
      		 
      SELECT *
      		 
      FROM default
      		 
      WHERE a < 10 OR b < 10;
      		 
       

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MB-22188 4.6.2 Minor Release

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              Prerna.Manaktala Prerna Manaktala (Inactive)
              gerald Gerald Sangudi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty