IIF versus calling a function

R

Rick Allison

Why is an embedded iif faster than calling a function from
a query?

For a field if I write iif(field>1,"yes","no") versus
function(field) the query is much faster.

Any reason why calling a function from a query is slow?

Thanks,

Rick
 
Top