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

[CX] Evaluate un-hinted query performance for CH2

    XMLWordPrintable

Details

    Description

      There are many ways to improve query plans using hints. However we'd need to make sure that an un-hinted version of a query performs reasonably well.
      To confirm that CBO plans are reasonable with and without hints we should compare runs of the CH2 queries with and without hints (at a DGM scale).

      1. Run an RBO version for each query (manually structured query to optimize performance).
      2. Run the original CH2 query.
      3. Run without skip-index hints.

      Attachments

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

        Activity

          There are no comments yet on this issue.

          People

            murali.krishna Murali Krishna
            till Till Westmann
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 40h
                40h
                Remaining:
                Remaining Estimate - 40h
                40h
                Logged:
                Time Spent - Not Specified
                Not Specified

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty