Re: Partitioned View??

There is an article on my web-site about v7 partitioned views. There are several details in there which might be relevant.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

ccdicky in hotmail wrote in message <80c90d$6cc1_at_imsp212.netvigator.com>...
>Hi there,
>
>Anyone can tell me how to make use of partitioned views? I have a table
>with more than 10 millions records. One of the column in this table is
>"DATE" type; therefore, I have divided the big table into 12 smaller tables
>by month and group these 12 tables into a partitioned view following the
>steps mentioned in Oracle Tuning Guide.
>
>All my queries can seems this partitioned view just equvalent to the big
>table; however, the queries need more time to run if I use the partitioned
>view instead of the big table. For example,
>
>select * from paritioned_view where date >= '10-JAN-99' and date
><='25-FEB-99';
>
>Note that the 'DATE" column has been indexed.
>
>It doesn't make any sense to me since I guess the excution plan for above
>query first is to select two corresponding month tables (JAN,FEB), and then
>retrieve the needed records from these two tables in parallel. Therefore,
>the run time for above query is somehow faster than the one using the big
>table instead.
>
>Thanks in advance.
>
>Dicky
>
>
Received on Wed Nov 10 1999 - 13:52:54 CST