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

Add field "keyspace_alias" to current index for Advise stmt

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.5.0
    • 6.5.0
    • query
    • Untriaged
    • Unknown

    Description

      "results": [
      {
      "#operator": "Advise",
      "advice": {
      "#operator": "IndexAdvice",
      "adviseinfo": [
      {
      "current_indexes": [

      { "index_statement": "CREATE PRIMARY INDEX #primary ON `travel-sample`", "keyspace_alias": "travel-sample" }

      ],
      "recommended_indexes": {
      "covering_indexes": [

      { "index_statement": "CREATE INDEX adv_type_id_c1 ON `travel-sample`(`type`,`id`,`c1`)", "keyspace_alias": "travel-sample_t1" }

      ],
      "indexes": [

      { "index_statement": "CREATE INDEX adv_type_id ON `travel-sample`(`type`,`id`)", "keyspace_alias": "travel-sample_t1", "recommending_rule": "Index keys follow order of predicate types: 2. equality/null/missing, 5. less than/between/greater than." }

      ]
      }
      }
      ]
      },
      "query": "select c1 from `travel-sample` t1 where type =\"route\" and id <10;"
      }
      ]

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              chang.liu Chang Liu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty