Re: selects on views are slow while on tables fast

From: <dalalbm_at_my-deja.com>
Date: Tue, 19 Oct 1999 18:07:09 GMT
Message-ID: <7uic03$m2f$1@nnrp1.deja.com>

Your description clearly shows you are using some where clause in the definition of the view. And the table does not have an index on that column(s). Verify the where clause in the view definition.

In article <380BACEA.6465E3D5_at_charlestoncounty.org>, Peter Shankey <shankeyp_at_charlestoncounty.org> wrote:
> version 7.3.3
> 5 tables have views created. The views are very simple, all the views
> are is just one table except a couple of the columns use the nvl
> function. A query run against the tables and using 'explain plan'
shows
> a cost of 37. The query uses all the indexes as it should. The same
> query run against the views of the tables returns a cost of 21997.
The
> query uses alot of full table scans. Why is this happening?? I
thought
> simple views like the ones being used would provide a alias for the
> table? I am sure that these views do not use any joins or perform any
> advanced calucations.
> Any ideas???
>
> thanks
> pete
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 19 1999 - 13:07:09 CDT