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

Work item to make GSI index as the DEFAULT INDEXING method for Couchbase/Sherlock.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.0.0
    • 4.0.0
    • query
    • Security Level: Public
    • Untriaged
    • Unknown

    Description

      Currently the two following statements are equivalent.
      > create index i1 on customer(c1,c2);
      > create index i2 on customer(c1,c2) using view;

      To create GSI index, you've to explicitly name it.
      > create index i2 on customer(c1,c2) using gsi;

      For Sherlock----->
      Make gsi index as the DEFAULT indexing method from N1QL.
      > create index i1 on cust-omer(c1,c2);
      > create index i2 on customer(c1,c2) using gsi;

      This also affects the default method for
      CREATE PRIMARY INDEX...
      DROP PRIMARY INDEX
      DROP INDEX

      Attachments

        Issue Links

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

          Activity

            People

              gerald Gerald Sangudi (Inactive)
              keshav Keshav Murthy
              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