PFCSIG view

[Asim Chakraborti]

Hi all
I have one query . Is there any advantage of using View ( useing more than
two tables ) rather than direct select sql with join in where clause for SQL
EXECUTION PERFORMANCE poit of view .
Is view faster than direct sql ? I am useing oracle 7.3.
Each table contains data more than 50000.

Asim

> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE:   help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]