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 -> Re: Snapshot for optimizing views

Re: Snapshot for optimizing views

From: hazledid <david.hazledine_at_roche.com>
Date: Fri, 07 May 1999 15:17:41 GMT
Message-ID: <puDY2.5519$vY2.18825@c01read01.service.talkway.com>


Our experience with snapshots in Oracle 7.3.3 has not been good. We found them unreliable and awkward to manage. If you're also on 7.3.3 I'd recommend tables rather than snapshots as the best means on insta ntiating your views.

David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674
Tel. +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Fri May 07 1999 - 10:17:41 CDT

Original text of this message

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