I have a query which accesses a partition view whose base tables are on a
remote database. I have created identical indexes on all the base tables of
the partition view, but the optimizer is still making a full table scan on
each of the base tables. Is it possible for oracle to take advantage of an
index on the base tables of a partition view, or will oracle ALWAYS make a
full table scan on the base tables?
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 07 1999 - 20:03:20 CDT
