Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to optimize readonly data ?

How to optimize readonly data ?

From: Michael Keppler <Michael.Keppler_at_bigfoot.com>
Date: Sat, 11 Dec 1999 15:15:37 +0100
Message-ID: <82tm2b$bt7@TGZ3>


Hello everyone !

I have a tablespace with data that is deleted and newly loaded from external data with sql loader 4 times a year. After loading the data and generating some indizes all the data will only be read for the next three months but not written.

What can I do to
* optimize the access time

--
Michael Keppler, MCSE, MCP+I
IT logic GbR
Michael.Keppler_at_gmx.de Received on Sat Dec 11 1999 - 08:15:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US