slower queries when not using substitution variables - 02/11/06 07:56 PM
Hello,
could you please explain me, why are large (complicated) queries so much faster when using substitution variables instead of other types (integer, string, date). If I run query in pl/sql developer the query is very fast (2 secs), when I run it within TOracleDataSet, the execution is so much slower (60 secs)...Of course, if I use substitution variables, then I have to be careful about right format of variable...
Thank you for the answer!
could you please explain me, why are large (complicated) queries so much faster when using substitution variables instead of other types (integer, string, date). If I run query in pl/sql developer the query is very fast (2 secs), when I run it within TOracleDataSet, the execution is so much slower (60 secs)...Of course, if I use substitution variables, then I have to be careful about right format of variable...
Thank you for the answer!