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

N1QL Index advisor for FTS

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Neo
    • Fix Version/s: Morpheus
    • Component/s: fts, query
    • Labels:
      None
    • Story Points:
      1

      Description

      Part 1

      • Generate index definition from query
      • Return a curl command to PUT fts index on a node hosting the search service.
      • Also compare the generated index definition with existing index definitions in the system for user to choose from based on a "sargability score".

      Part 2

      • Support a CREATE INDEX command for FTS indexes (MB-48298)
      • Once the command is supported, the index advisor can recommend a CREATE INDEX command as opposed to a curl command.

      Part3

      • CBO based cost between GSI vs FTS

        Attachments

          Issue Links

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

            Activity

            Hide
            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - - edited

            Index Advisor :
            Advice
            1. It collects all the expressions in the query based on keyspaces including the expression location.
            2. GSI index analyze those and comes up index definition. Here If passed to FTS they can recommend FTS index (curl or CREATE INDEX)
            3. Then dedup the indexes. FTS Can merge the indexes because it is easy no order of keys.
            4. Create Virtual Indexer (no bucket), index and validate the Index sargability. FTS should allow from step 2 create virtual (meta data only, no search performed).
            Advisor:
            Multiple statements. FTS can merge the indexes on the same collection. (Step 3)

            Show
            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - - edited Index Advisor : Advice 1. It collects all the expressions in the query based on keyspaces including the expression location. 2. GSI index analyze those and comes up index definition. Here If passed to FTS they can recommend FTS index (curl or CREATE INDEX) 3. Then dedup the indexes. FTS Can merge the indexes because it is easy no order of keys. 4. Create Virtual Indexer (no bucket), index and validate the Index sargability. FTS should allow from step 2 create virtual (meta data only, no search performed). Advisor: Multiple statements. FTS can merge the indexes on the same collection. (Step 3)

              People

              Assignee:
              abhinav Abhinav Dangeti
              Reporter:
              abhinav Abhinav Dangeti
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty