Re: Materialised view persformance

From: Mladen Gogala <>
Date: Mon, 30 Mar 2009 15:20:36 +0000 (UTC)
Message-ID: <gqqo04$l8a$>

On Mon, 30 Mar 2009 04:55:40 -0700, KevinS wrote:

> All,
> 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?
> Thanks

What does "much slower" mean? What event is your "count(*)" waiting on?

Received on Mon Mar 30 2009 - 10:20:36 CDT

Original text of this message