Non index column then index column in where clause

Couchbase Server
,
1

Hi,
I have a doubt, if we use non index column first then index column in where clause, or vice versa, is there any impact on query performance?

2

Hi @chain.singh31 - I suspect it won’t make a difference. You can examine the query plans in the webui in the Query tab. Make sure to use exactly the same query - especially with respect to parameters.

3

Location of predicates in query where clause will not make any difference on index selection or performance. except AND /OR conditions.

But note: WHERE a = 10 and b = 20 and c= 30
Index on a , but not b and c
While applying WHERE clause evaluation done left to right in that case a = 10 already applied every row eliminates b = 20 few extra instructions can be wasted but those will not see unless huge rows