Tuning sql with bind variables

Hi Tom, Here is a sample sql from a package used for searching clients. The query is very fast when we remove the "OR" condition "ln_cl_id is null" from the WHERE condition. There are many columns with similiar OR condition, which I have removed...

Read More...

---