Re: optimizing pl*SQL

From: RemarQ User <dmarsh_at_istar.ca>
Date: Sat, 05 Dec 1998 11:37:55 -0800
Message-ID: <iZfa2.697$45.1112466@WReNphoon1>

What version of Oracle are you using? If you are using previous to 7.2 with the cost-based optimizer, that could be the problem. The cost-based optimizer was quite flakey in earlier versions or Oracle7 and often made bad decisions when determining the execution plan. Try the rule hint as someone else in this thread had pointed out. The rule based optimizer will generally try to use an index when possible as opposed to a full table scan.

Good luck!

Dave

-**** Posted from remarQ, Discussions Start Here(tm) ****- http://www.remarq.com/ - Host to the the World's Discussions & Usenet Received on Sat Dec 05 1998 - 13:37:55 CST