Views

[sajai]

I have a query which unions the four select statements.....

the select statements are joined with other tables and views.....


When i execute the query i get ODBC timeout error........

But the strange thing is that if i execute the view individually once and again execute the query it works fine.......and later it justs works fine....

Can anyone tell why is it like that.......

Thanks,
Sajai.

------------
sajai at 3/26/01 4:07:55 PM

I have a query which unions the four select statements.....

the select statements are joined with other tables and views.....


When i execute the query i get ODBC timeout error........

But the strange thing is that if i execute the view individually once and again execute the query it works fine.......and later it justs works fine....

Can anyone tell why is it like that.......

Thanks,
Sajai.