Re: Help please - View as union of multiple small tables

I would suggest that you download Oracle8i Personal Edition to try out partitioning to see if it helps or not... if yes, then show the difference (or business value of having partioning options) to the person having power to approve the budgets...

HTH
http://www.webyourcompany.com  

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0305300601.352057b_at_posting.google.com>...
> Hi,
> more specifically my oracle version is oracle 8i (8.1.7.4). Yes
> partitioned tables is better/right way to go as opposed to partition
> views.
> But i guess the parititioned tables is available only in Oracle
> Enterprise edition. If one were to stick with 8.1.7.4 standard, then
> where to look for????
> (EE is costly and especially when one wants to distribute and
> scale..additional licenses will boost up the price)
>
>
>
>
>
> JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0305291720.59ee190_at_posting.google.com>...
> > avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0305291400.2d4a1038_at_posting.google.com>...
> > > Hi oracle gurus,
> > >
> > > Let me admit first this. I dont much of oracle except using it do some
> > > DDL and DML.
> > > GOAL :I have a very large table and have to split into multiple
> > > smaller tables (so that writes can speed up). Now for reporting
> > > purposes, I cannot expose all these tables. So I decided to create a
> > > View which is UnionAll of these multiple small tables. Also, in our
> > > case as the data keeps growing and tables get added dynamically.
> > >
> > > How do i go about doing this while ensuring at any time only one small
> > > table is scanned as opposed to all tables ???
> > >
> > > I dont know what is an EXPLAIN PLAN ??? what is tkprof etc... to know
> > > what oracle is doing when a query on the full view is done ????
> > >
> > > I am using Oracle 8i.
> > >
> > > Any help in this regard is appreciated. Actually i read couple of
> > > articles in google about partition views but i got lost.
> > >
> > > Can Any body who can explain me in simple terms ???
> > >
> > > -thanks in advance,
> > > avsrk
> >
> > Partitioning is what you really need.
> >
> > - Jusung Yang
Received on Fri May 30 2003 - 19:50:40 CEST