Yes, plans are the same (there might be minor differences, I do not remember
the details but both plans have two full table scans).
V. Oguz TOKMAK
"Jim Smith" <jim_at_jimsmith.demon.co.uk> wrote in message
news:gFbNjeU0DWDEFw2I_at_jimsmith.demon.co.uk...
> In message <440d4cb2$0$2926$9a6e19ea_at_unlimited.newshosting.com>, vahapt
> <vahapt@[at'no'Spam].invalid> writes
>>Hi,
>>Instead of sending prepared statements, we've sent a plain query from jdbc
>>there was no difference. Timings for prepared statement and plain query
>>are
>>the same.
>>V. Oguz TOKMAK
>>
>
> Are you getting the same execution plan from the iSQL*Plus and Java
> versions? Try tracing the sessions and see what is happening.
> --
> Jim Smith
> I'm afraid you've mistaken me for someone who gives a damn.
Received on Tue Mar 07 2006 - 07:41:58 CST
