Re: Optimization

Hello!
If your database is in 'CHOOSE' Optimizer -mode then the coste Based Optimizer will involved in all Queries for tables which have statistics.

You can see that thru the explain-plan of an statement or tkprof which optimzer was involved.
Bye

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!