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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problem with complicated select process.

Re: Problem with complicated select process.

From: Paul Dorsey <DORSEY_at_RIDER.BITNET>
Date: Sun, 19 Mar 1995 15:54:41 -0500
Message-Id: <9503192156.AA31474@alice.jcc.com> 





I don't hold myself up as a great SQL expert but consider how much
you paid for the advice...



Have you thought of trying to redundantly store data in your
table to avoid the joins?  It looks like 2 little violations
of denarmalization and you could be off to the races.  It looks
like it is the sub queries that are killing you.
Paul Dorsey


Rider U

Received on Sun Mar 19 1995 - 16:56:15 CST












Original text of this message













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