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
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.