Performance of Inline views

From: John Vernes <vernes.j_at_consunet.nl>
Date: Sat, 16 May 1998 20:12:46 +0200
Message-ID: <6jkl2b$r80$1@news.worldonline.nl>

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 Received on Sat May 16 1998 - 13:12:46 CDT