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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Busted IIf function 3
nested iif function 4
IIf statement too long. Other options? 4
Problem with SET & REF function 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
iif statement within query 3

Top