Re: Materialised view persformance
Date: Mon, 30 Mar 2009 15:20:36 +0000 (UTC)
On Mon, 30 Mar 2009 04:55:40 -0700, KevinS wrote:
> When I do a "select count(*)" from a materialised view I have created
> and compare the execution time with the same select on the table the
> materialised view is being driven off, the time for the materialised vew
> is much slower even though the number of rows is the same.
> Is this behaviour to be expected or might the materialised views been
> set up incorrectly?
> If it's the latter what should I check?
What does "much slower" mean? What event is your "count(*)" waiting on?Received on Mon Mar 30 2009 - 10:20:36 CDT