On 6/14/07, Paul Vincent <Paul.Vincent@xxxxxxxxx> wrote:
On a system which otherwise generates very little redo (since about 99% of all transactions are read-only, using only SELECTs), we have a materialized view which is refreshed once an hour. This was introduced to give a far better response time on a common query type which ran in 15 seconds without the view, but now runs in a second or less, using the materialized view.
Refresh type? (full or fast) Re the previous question: Is there a log(s) on source table(s)? (there will be for fast refresh) Database version? (it matters...) -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist