Re: Snapshot for optimizing views

From: Kekko <dini.f_at_adr.it>
Date: Fri, 07 May 1999 14:37:37 +0200
Message-ID: <3732DE91.7F7A8E78@adr.it>

J suggest Snapshots which can stay on the same database. Kekko.

boica_at_hotmail.com wrote:

> I need to optimize the frequent calling of views, maintaining the data
> retrieved by them in a "frozen" state, during the execution of a program.
> For this, which is the best solution in terms of performance and design: use
> snapshots, or model tables to store the data retrieved by the views? PS: the
> "master" tables, views, are all created in the same database.
>
> Regards,
> Renato
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri May 07 1999 - 07:37:37 CDT