Re: Partitioned Views

From: Michael S. Abbey <masint_at_istar.ca>
Date: 1998/03/21
Message-ID: <351431a1.1129764@news.istar.ca>#1/1

On Wed, 18 Mar 1998 18:12:11 -0500, Dennis M Regan <dregan_at_frontiernet.net> wrote:

>Help,
>
>I've partitioned a very large table into serveral smaller tables using
>date field criteria as the partition. Next, I created indexes on all the
>partitions for this date field. Then I alter the tables to create the
>check constraint (date_file between ...). I then analyze the tables and
>create the view using union all. When I query the view, I specify a date
>in the where clause, and Oracle does an index range scan on all the
>tables! Why doesn't and isn't Oracle supposed to be able to eliminate
>partitions? What's up?
>
>DR
>

My experience has shown that partition elimination elimination working is questionable.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Sat Mar 21 1998 - 00:00:00 CST