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: Query a partitoned table for data spanning in multiple partition

Re: Query a partitoned table for data spanning in multiple partition

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sun, 30 Jan 2005 22:47:32 GMT
Message-ID: <8udLd.17458$MX2.4378@twister.nyroc.rr.com> 






"Rishi Pahuja" <rishipahuja_at_rediffmail.com> wrote in message
news:1107118815.325327.135570_at_c13g2000cwb.googlegroups.com...


> Making a Union of two big Select will be a costly option.

>

> I wish to know, if we have a better alternative other than union.

> Thanks,

> Rishi

>




You would be be doing a "union all" ... why do you think that will be more
costly than doing two selects?



Anurag
Received on Sun Jan 30 2005 - 16:47:32 CST












Original text of this message













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