Re: Accessing 2 tables with 1 name

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 7 Jul 2003 21:19:53 +0100
Message-ID: <3f09deef_1@mk-nntp-1.news.uk.worldonline.com>

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3F098553.7BB05EA3_at_remove_spam.peasland.com...
> We had one major problem, which was a large join took forever to
> complete. A query that the developers originally designed needed data
> from this join. We wanted to precompute the join and store the results
> in a table and have the application query from this table. This table
> gets "refreshed" once a day. Missing a days worth of data, between
> refreshes, was not a problem for us. And this took our query from hours
> down to seconds. So our application end users were happy.
>

Again I agree with Brian. Back in the mid-80's we were using what we then called 'preaggregated redundant tables' to speed query execution, on a Wang mini, using the proprietory RDBMS.

Much less is new than most think

Regards,
Paul Received on Mon Jul 07 2003 - 15:19:53 CDT