Materialised view persformance
From: KevinS <SearleK_at_googlemail.com>
Date: Mon, 30 Mar 2009 04:55:40 -0700 (PDT)
Message-ID: <46df369b-242c-4b47-aa8a-30cda5ad5c18_at_r37g2000yqn.googlegroups.com>
All,
Date: Mon, 30 Mar 2009 04:55:40 -0700 (PDT)
Message-ID: <46df369b-242c-4b47-aa8a-30cda5ad5c18_at_r37g2000yqn.googlegroups.com>
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 Received on Mon Mar 30 2009 - 06:55:40 CDT