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,