Re: selects on views are slow while on tables fast

From: <michael_bialik_at_my-deja.com>
Date: Tue, 19 Oct 1999 20:16:28 GMT
Message-ID: <7uijif$rpo$1@nnrp1.deja.com>

Hi.

Post table and views definitions and both EXPLAINs.

Michael.

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 - 15:16:28 CDT