Do you really need the distinct? I bet you can lose that and get some
performance.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"buckeye234" <member13594_at_dbforums.com> wrote in message
news:2643978.1047654293_at_dbforums.com...
>
> Here is the SQL statement, it looks pretty innocent:
>
> SELECT distinct A.*,B.*,C.*,E.*,F.*
> FROM COMPUTER_INFO A,
> CD_INFO B,
> HARD_DRIVE_INFO C,
> HNETWORK_CARD_INFO D,
> USER_INFO E,
> ADDITIONAL_INFO F
> WHERE A.COMPUTER_ID = B.COMPUTER_ID(+)
> AND A.COMPUTER_ID = C.COMPUTER_ID(+)
> AND A.COMPUTER_ID = D.COMPUTER_ID(+)
> AND A.COMPUTER_ID = E.COMPUTER_ID(+)
> AND A.COMPUTER_ID = F.COMPUTER_ID(+)
>
> Explain plan to follow ....
>
> --
> Posted via http://dbforums.com
Received on Fri Mar 14 2003 - 23:15:51 CST
