select /* all_rows */x1,x2,x3
from view_x
where x1 in
(select a.b1 from mytable a,mytable2 b
where a.b2=b.c2)
as view_x
is a view, which is trying to get the data from the other source(@othertable_dblink
)
I have index on b1. but as view_x is a view , I don't have privilege to create a index on that.
NOTE: Due to this, the mytable and mytable2 are going on error like "table access full"
My Question: How can I reduce the time on this, by not allowing it to go for "table access full"
if there are any query tuning techniques , pls let me know.