Re: Help please - View as union of multiple small tables
Date: 29 May 2003 18:20:50 -0700
Message-ID: <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