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 -> sun sparc oracle solaris--- && troubles

sun sparc oracle solaris--- && troubles

From: <siad_at_my-deja.com>
Date: Fri, 29 Dec 2000 15:56:40 GMT
Message-ID: <92ic7l$gb7$1@nnrp1.deja.com>

hi all...
we have a sun station with solaris and oracle on it.......and its incredible slow!!!
some statements take about 1 min (on my notebook few secs)....especially a OR-clause in a statement with a 4table join gets incredible slow....but if i devide the statement into 2 statements....the 2 are very fast....shouldnt oracle do the same (devide the join and then bring it together)?????

thx in advance....siad

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 29 2000 - 09:56:40 CST

Original text of this message

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