Re: Why are version 6 views so sluggish? How to improve?

In article <keith.w.johnson.173.000C8EA2_at_tek.com> keith.w.johnson_at_tek.com (Keith W. Johnson) writes:
>Neophyte asks...
>
>I support an old version 6 database on a small VAX/VMS machine. I just
>removed some common logic from several SQL*plus batch jobs and created a view
>that performed the same logic. The original SQL was then modified to include
>the view in a join. So... same logic, just implemented differently.
>
>No indexes were changed. Only about 50 rows result from the logic in the
>view. That view is joined to another rather large table. I was hoping the
>query engine would evaluate the view and process it once and the results
>simply stored in a cache.
>
>My run times increased by at least an order of magnitude. Why?
>
Have you used Explain Plan to see how Oracle intends to use the indexes? Depending on how you constructed the view, Oracle may be precluded from using the indexes in a manner the seems logical to you.

Re-post your question (assuming you've run Explain Plan and that does not help) with a copy of the CREATE VIEW statement along with index descriptions and your question may get a more helpful answer.

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Northrop Grumman    | the other is total destruction. Let us choose wisely.
============================================================================