Index access into Partition View?

From: <garrett.vance_at_pgees.com>
Date: Thu, 08 Apr 1999 19:39:11 GMT
Message-ID: <7ej0ku$tnc$1@nnrp1.dejanews.com>

I have created a partition view in oracle 7.3.4; I am attempting to tune a query against this partition view, but I find that the optimizer seems to ignore indexes created on the base tables in favor of a full table scan. Will the optimizer ever choose index access into a base table of the partition view, or will oracle ALWAYS make a full table scan of the base table???

Thanks In Advance,
Garrett Vance

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 08 1999 - 14:39:11 CDT