Performance of Inline views

Performance of Inline views

Post by John Verne » Sun, 17 May 1998 04:00:00



Is there anyone out there who has allready been experimenting
with the use off inline views?

For example:
Are inline views allways build up before joining other tables??
Is the use of temporary tables faster then inline views?

example:

select ....
from   table_a, table_b, (select * from table_c, table_d where .... )
where ....

Any info regarding performance and the use of optimizer with online views is
welcome.

Thanks in advance!!
Greetings John