Re: [GENERAL] Improving performance with a Function instead of a

2004-02-05 Thread Kris Jurka
On Thu, 5 Feb 2004, Hadley Willan wrote: > Thanks, but I don't believe this to be a problem because my JDBC layer > when I construct the query is using setObject( parameter, getId, > Types.BIGINT ) > > so by the time it arrives at the database that cast should have already > occured? > The JDBC

Re: [GENERAL] Improving performance with a Function instead of a

2004-02-04 Thread Hadley Willan
Thanks, but I don't believe this to be a problem because my JDBC layer when I construct the query is using setObject( parameter, getId, Types.BIGINT ) so by the time it arrives at the database that cast should have already occured? I could be wrong but running the Explain Analyse shows indexe