Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> selects on views are slow while on tables fast
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
Received on Mon Oct 18 1999 - 18:27:38 CDT