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 -> Re: Oracle, speed up query

Re: Oracle, speed up query

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 22 Jul 2004 19:52:03 +0200
Message-ID: <ejvvf094dnu3prtmrefh4i3sgio8s8tgcs@4ax.com> 





On 22 Jul 2004 08:03:46 -0700, luvieneq_at_hotmail.com (Louis) wrote:



>Is there a way to speed up my query.




foreign keys shouldn't be null. Outer joins should be an exception.
Treating outer joins as normal is usually a sign of an ill-designed
system, and almost invariably gives lousy performance.
Redesign is in order.



--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Jul 22 2004 - 12:52:03 CDT












Original text of this message













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