view or table? help

We had some in-house complicated script which used views as middle query and they all seemed to work fine at beginning. Some time laser the scripts took longer and longer to finish. If we change the views to temporary table it would improve the perfomance a lot.

Would any oracle expert tell me why?

Thanks thousand in advance.

my scripts like

create view ...
...

create view ...
....

select .... from tables, views
where ....  

Limin Guo
Andrews University Received on Thu Jan 30 1997 - 00:00:00 CET