Hi, I'm using Couchbase Server 3.0 and N1QL DP 4. I have created a index for optimizing my queries performance, this is the sentence for the index:
CREATE INDEX `restaurantId` ON `shadow_casaargentina`(restaurantId); Everything appears to work fine but an specific query are giving me some troubles: SELECT * FROM shadow_casaargentina WHERE docType='table' AND (status='busy' OR status='locked') AND (restaurantId=5); Without the index this last query works fine, but with the index takes a lot of time (I have been waiting for an hour with not answer yet). I think that the only diferrence between the other queries is the 'or' statement. Does anyone knows why this could be happen? Regards! -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
