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

Since you're using Oracle 8i...(hope it's 8.1.7.4 because it's the only supported release now) please don't spend time on partition views. From your description partitioned tables would be the way to go.

Partitioned views were used briefly in version 7.3 before partitioning was
available. Post 7.3, partitioned views are not recommended and not being enhanced at all.

You need to learn Explain and tkprof in order to tell that if partitioning (or any other features) does help you or not.

HTH
http://www.webyourcompany.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
Received on Fri May 30 2003 - 03:13:49 CEST