view is not using index
i created view with underlying tables each having 10 GB of size.
when i explain each underlying table it is using index but when try to explain the query in view it causes full table scan on all underlying tables
which caused performance.
how make view to use index
Subject
Written By
Posted
view is not using index
October 24, 2016 08:30AM
November 02, 2016 12:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.