They wanna know why it takes so long .....

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