Snapshot for optimizing views

  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