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