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?
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.
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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.