Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned view question
Have you set the init.ora parameter:
partition_views_enabled=true ?
Have you analyzed the table so that the optimizer realises they are large enough to make the overhead of partition elimination worthwhile ?
If this doesn't help, then there is a document on my website that might be worth a quick look.
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Gregert Johnson wrote in message <37431728.3337E479_at_ctron.com>...
>Hello -
>
>We are trying to implement partitioned views under Oracle 7.3 running on
Solaris. Our problem is that after defining tables which
>are the components of a view and adding constraints which define the
partition ranges (check clauses on the partitioning column),
>we've not been able to get the query optimizer to choose a table to scan -
it always scans all tables in the view when parsing a
>simple SELECT:
>
> SELECT * FROM VIEW
> WHERE PARTITION_COLUMN = <VALUE>;
Received on Wed May 19 1999 - 15:54:41 CDT