Re: How to tune a SQL with 4 sbu-queries?

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Wed, 26 Sep 2001 16:09:14 +0800
Message-ID: <mu23rt44ajpbmb0k9os61nstlh4o1f1is8@4ax.com>

On Wed, 26 Sep 2001 15:07:21 +0800, Dino Hsu <dino1.nospam_at_ms1.hinet.net> wrote:

>Dear all,
>
>Thanks for replies from Sybrand, Galen, and Mark, I am doing something
>according to your advices, I will post the result.
>
>One more question is what on earth is 'query rewrite'? I encountered
>this when doing FBI (function-based index), and I met it again with
>MTV (materialized view). Jason Couchman mentioned it too. I cannot
>even figure out its literal meaning. What is 'rewrite'? Re-write what?
>Thanks for your help.
>
>Dino

Galen's suggestion to create a materialized view for the 'base view' to be further queried is nice, but it's sad to find that 'REFRESH FAST' cannot be used when analytic functions such as SUM is present. 'REFRESH COMPLETE' seems to be unavoidable, this will still be much faster than the original 4 inline-views, though.

Dino Received on Wed Sep 26 2001 - 03:09:14 CDT