Hi,

If I have multiple where conditions in my SQL, is it possible to specify
its order, so that the query
can be executed more efficiently?

For example, if I have the following SQL, it used a heavy UDF that needs to
access database.
However, if I can specify the order of conditions is executing
`!user.is_robot` first then executing
UDF, it will reduce the number of database access. Those records with
`true` in `user.is_robot` will
be dropped earlier and don't need to access database.

select *

from users

where !user.is_robot and UDF_NEED_TO_QUERY_DB(user)


Thanks,
Tony Wei

Reply via email to