Re: Materialised view persformance

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 30 Mar 2009 15:20:36 +0000 (UTC)
Message-ID: <gqqo04$l8a$1_at_solani.org>



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?

-- 
http://mgogala.freehostia.com
Received on Mon Mar 30 2009 - 10:20:36 CDT

Original text of this message