Views are more meant for providing consistency, security features, rather than performance. In fact if you were to look at it from a pure performance stand point, views are a little slower than a direct SQL statment, as the database has a small extra step to search for the view and then execute it. In any case, did you try benchmarking view vs the regular SQL stmt ? Surya ----Original Message Follows---- From: [EMAIL PROTECTED] (Asim Chakraborti) To: <[EMAIL PROTECTED]> Subject: PFCSIG view Date: Fri, 20 Aug 1999 15:48:07 +0530 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] _______________________________________________________________ Get Free Email and Do More On The Web. Visit http://www.msn.com > [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]
