Improving query with multiple OR clauses

[vsr1]

normally it doesn’t matter. LIKE on index key then in main query, you see difference in spans.

[krishan.jangid]

One more thing… How can I disable profile through cbq?

[krishan.jangid]

Got it from the link you shared. Thanks a lot for your help.

[krishan.jangid]

@vsr1, Can you suggest the best way to change the indexes from forestdb to plasma in existing installation? Also do let me know what particular step I need to take while upgrading old version of couchbase so that Legacy Global Secondary index is not selected.

[jeelan.poola]

@Krishan, Could you please confirm if you are using Couchbase Enterprise Edition? Plasma is available only in EE and Standard GSI indexes in existing installation(s) will be automatically upgraded from forestdb to plasma when upgrading to Couchbase server EE 5.0.x.

[krishan.jangid]

@jeelan.poola, The version after upgrade is 5.0.1-5003-enterprise.

I have created a separate thread for this issue. Could you please respond on that?
here’s the link:

Changing index type from forestdb (Legacy GSI) to plasma (Standard GSI)

Hi, I have upgraded a single node couchbase cluster from version 4.6.2 to 5.0.1 Enterprise Edition But, in the settings, the indexer service is showing index type as ‘Legacy Global Secondary’. Since it is old forestdb, all the queries are taking time even with proper indexes. How can I change the index type to plasma with minimum efforts? What option is there on the time of upgrade that decides which index technique to use from these two ? Please let me know.