Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> outer joins..

outer joins..

From: <sunita_at_postoffice.worldnet.att.net>
Date: 15 Aug 1998 12:08:04 GMT
Message-ID: <35D57C88.1081@postoffice.worldnet.att.net> 





Can you please explain why it is behaving like this:



WHen a query is expected to return fewer rows, outer joins
bring back teh results quickly.



WHen the query is expected to return large # of rows,
regular joins bring back the results quickly..



WHY????

Received on Sat Aug 15 1998 - 07:08:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US