Since you are using 7.3 investigate Partitioned Views. They should help. If
you can move up to 8.0.5 or 8.1 physical partitioning is a good option, that
should prove significant in enhancing your query performance.
--
Bob Fazio
Remove no.spam from my email to reply
Tim Theis <ttheis_at_dytn.veridian.com> wrote in message
news:7qekhn$2mv$1_at_athena.netset.com...
> I have a view set up like...
>
> Create View View1 as
> Select A.field1,A.field2,sum(A.field3)
> From
> Table1 A
>
> I now want to issue a select statement on this view similar to the
> following...
>
> Select * from View1 where field2 = 'PARAMETER'
>
> and have the underlying view1 know to restrict the query to only those
> records where field2='Parameter'. All of my experimentation seems to prove
> that Oracle creates a temporary table of all possible values first, and
then
> restricts the rows in the temporary table to those meeting the condition.
> Since this is a very large table, it is very inefficient.
>
> Any help would be appreciated. I am using Oracle 7.3.
>
> Tim Theis
> ttheis_at_dytn.veridian.com
>
>
Received on Mon Aug 30 1999 - 20:07:53 CDT
