Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Optimizer

Optimizer

From: SHRIKE <tdeseamus_at_impacthire.com>
Date: Thu, 14 Dec 2000 16:17:16 -0600
Message-ID: <t3ihe71h9vk00c@corp.supernews.com>

I have some PL/SQL code that retrieves records based on user supplied criteria that runs against a view. The optimizer forces the view to be run before the index and a full table scan to be run against the view. This has caused the operation to slow down considerably. Does anyone know of a way to force the index to be run before the view? We have tested replacing the view with imbedded sql statements, and this works, however this course would involve a great deal of code re-write.

Thanks,
Tom Received on Thu Dec 14 2000 - 16:17:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US