I enconter a strange problem when select from a view.
When I send the query:
Sel * from db1.vxxx;
The parsing time is very long to 5 minutes.
But when I send the query to select from the base table:
Sel * from db1.txxx;
It sends the results in less than one second.
The definition of the view is :
REPLACE VIEW db1.vxxx AS LOCKING ROW FOR ACCESSSELECT * FROM db1.txxx ;
When I change the user (to change workload), there is no such problem. The select from the table and the view send the results both in less than one second.
I have checked that there is on flow control when I execute these queries.
Anyone can explain this problem?
Thanks in advance