I have a query with an OR statement that looks like this:
SELECT * FROM BucketName WHERE Obj.Name='somwthing' OR Obj.NameEng='something'
I have created these indexes, but none of them is being used (I am using the “explain” query to check).
CREATE INDEX `ind1` ON `BucketName`(Obj.NameEng) CREATE INDEX `ind2` ON `BucketName`(Obj.Name) CREATE INDEX `ind3` ON `BucketName`(Obj.Name,Obj.NameEng) CREATE INDEX `ind4` ON `BucketName`(Obj.Name or Obj.NameEng)
What is the correct create index statement for the above query?
Currently using Couchbase 4.5 community , with a plan to move to 6.0 very soon.