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

N1QL:As of now there is no plan seen in explain clause of a query including subqueries

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Duplicate
    • Major
    • None
    • 5.0.0
    • query
    • None

    Description

      I see expression scan being used for queries having constants like:

      explain SELECT p.x FROM {"p":[{"x":11},{"x":12}],"q":"abc","r":null}.p;
      

      but cant find any subqueries on a bucket which show expression scan or any plan information for that subquery.
      Example:

      explain SELECT custId, id FROM orders WHERE "lunch" IN (SELECT RAW orderlines.productId FROM orders.orderlines);
      

      After discussion with Sitaram, it seems there is no plan produced for subqueries and this can be an improvement.

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              keshav Keshav Murthy
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty