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

Home -> Community -> Usenet -> c.d.o.tools -> union problem

union problem

From: <kazelot_at_thenut.eti.pg.gda.pl>
Date: Tue, 12 Jun 2001 12:26:59 +0200
Message-ID: <Pine.LNX.4.33.0106121216580.13915-100000@thenut.eti.pg.gda.pl> 






I have two sql queries joined with union.
Each query separately executes in about 0.1s.
query1 union query2 takes more then 50s, which is about 500 times more.



Is it possible? I mean it is because I got this results :-), but what what
could happend?



Thanks for any suggestions,


kazelot
Received on Tue Jun 12 2001 - 05:26:59 CDT












Original text of this message













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