Re: [GENERAL] Date Parameter To Query Confusing Optimizer

2011-01-04 Thread Kurt Westerfeld
?::date and ?::date ..." syntax or send statement causing problems? Kind regards, Radosław Smogura On Tue, 04 Jan 2011 07:27:42 -0700, "Kurt Westerfeld" wrote: > "By the very definition of a prepared statement the query plan gets > stored before the parameter values are

Re: [GENERAL] Date Parameter To Query Confusing Optimizer

2011-01-04 Thread Kurt Westerfeld
1 2:21 AM >>> On 3 Jan 2011, at 23:48, Kurt Westerfeld wrote: > I have a JDBC-based application which passes date/time parameters using JDBC > query parameters, which is performing very badly (ie. doing full table > scans). In an effort to try to narrow down the problem, I am t

[GENERAL] Date Parameter To Query Confusing Optimizer

2011-01-03 Thread Kurt Westerfeld
I have a JDBC-based application which passes date/time parameters using JDBC query parameters, which is performing very badly (ie. doing full table scans). In an effort to try to narrow down the problem, I am taking the query and running it in interactive SQL mode, but changing the date paramet