Re: Where Clauses: IN versus =

Andy Hassall wrote:

> A simple test indicates that Oracle generates the same execution plan for "in
> (:x)" versus "= :x" which makes sense since it's semantically identical.

> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Thanks Andy, I appreciate your time.

Our server (I'm not the DBA) gives me SP2-0613 and SP2-0611 error when I try the autotrace - I'll need to get our DBA to implement a plan_table, I think.

-- 
Tim    http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto  "TIM-MAY!!" - Me