Andy Fish wrote:
>> select pk, data from foo where pk in (select fk from bar);
>>
>
> thanks for this hint (and to cleveridea) for the other one.
>
> any idea if either of these have significant performance deteriment compared
> to the basic select ?
Test on your system with your hardware. There are no generic answers to
this question.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Sep 06 2007 - 09:00:41 CDT
