Optimizer

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