I am using a table (tabA) in a complex query with index hint. There is a need I need to get the data from another table tabB as well, both the tables have same structure and similar data. Because of a business need I need to create a view like
create or replace view tabAtabB (a,b,c) as
select a, b,c
Select a, b, c
I am using tabAtabB in my complex query instead of tabA. Now the query is doing full table scan on tabA, however it was using the index previously. tabB has very less data, hence I can afford full table scan on tabB but cannot afford to have FT scan on tabA.