From: Yong Subject: Re: Is using views always slower than using base tables? Date: 2000/07/07 Message-ID: <233fb852.4e1c4f6a@usw-ex0104-026.remarq.com>#1/1 References: <8k2p93$eqv$1@nnrp1.deja.com> <3965d4c1@grissom> Bytes: 1257 X-Originating-Host: 163.188.121.35 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon3 962978203 10.0.2.26 (Fri, 07 Jul 2000 06:56:43 PDT) Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here NNTP-Posting-Date: Fri, 07 Jul 2000 06:56:43 PDT Newsgroups: comp.databases.oracle.server X-Wren-Trace: eOPG7u/2sfuwuvjl4fCwu9Hp8u7p6O326eKssbyktPK0ve2zv/K4vro= Thank you, Gary. I'm very interested in your cited reference. Could you tell me where I can find it? Yong Huang yong321@yahoo.com "Gary Healy (Powerup)" wrote: >Views have proved to be slower in 8.0.6 when joining to base tables that >when used in 7.3.4. The execution plan from 7 -> 8 is way different. > wrote in message news:8k2p93 $eqv$1@nnrp1.deja.com... >> Is using views always slower than using base tables, at least >> theoretically? My developers ask me to create views for them. I told >> them views are used for two purposes: for convenience so that you don't >> have to remember or type in all the base tables and their column names; >> for security so as to hide some column or table names. My developers >> are not end users. They don't need the convenience and they should be >> allowed full select privilege on base tables. For performance reason, >> views are always slower than or indistinguishably the same as using >> base tables. Is this correct? >> >> Yong Huang >> yong321@yahoo.com ----------------------------------------------------------- Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free! http://www.keen.com