Long pasing time for a simple query for a specific workload

Database
Enthusiast

Long pasing time for a simple query for a specific workload

Hi,

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 ACCESS
SELECT * 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

Mike

Tags (1)