Re: READ-ONLY Tables and Views

In article <4ejvpr$bsm_at_ebola.netup.cl> "Eduardo Díaz" <ediaz_at_dgf.uchile.cl> writes:
>Path: nntp.teleport.com!news.reed.edu!usenet.ee.pdx.edu!newsrelay.netins.net!solaris.cc.vt.edu!newsfeed.internetmci.com!in1.uu.net!manquehue.scc.puc.cl!ebola.netup.cl!usenet
>From: "Eduardo Díaz" <ediaz_at_dgf.uchile.cl>
>Newsgroups: comp.databases.oracle
>Subject: Re: READ-ONLY Tables and Views
>Date: 30 Jan 1996 02:29:15 GMT
>Organization: NetUp, lo nuevo en proveedores Internet
>Lines: 6
>Message-ID: <4ejvpr$bsm_at_ebola.netup.cl>
>References: <4dl8q9$aco_at_sol.zynet.net> <4dm7n9$7f6_at_hammer.msfc.nasa.gov> <odysscci.537.00010EE3_at_teleport.com>
>NNTP-Posting-Host: modemca.netup.cl
>Mime-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>X-Mailer: Mozilla 1.1N (Windows; I; 16bit)
>To: odysscci_at_teleport.com

>When a Tablespace is read only, what's about the performance?
 

>Thanks
 

>Eduardo Diaz

I would think it would be good. Oracle does not have to maintain read consistency (since the data cannot change). So I would think if it does less work with the same results it should be no slower and might be faster.

Jim Kennedy Received on Wed Jan 31 1996 - 00:00:00 CET