Improving performance of this view.
From: BARRY ROOMBERG <barry.roomberg_at_compudata.com>
Date: Wed, 19 Oct 94 10:58:00 -0400
Message-ID: <89C1292.03890017E1.uuout_at_compudata.com>
Date: Wed, 19 Oct 94 10:58:00 -0400
Message-ID: <89C1292.03890017E1.uuout_at_compudata.com>
-> This view is a real workhorse for me (I use it in a variety of
-> applications) but runs a little slower than I'd like. I would like
-> to improve the performance of this view somewhat.
If you can use a static picture of the data, then create a table via "create table as select * from VIEW_NAME" and then index the relevent fields. Have it run nightly and then select against the result. Received on Wed Oct 19 1994 - 15:58:00 CET