Re: Optimization

select value from v$parameter where name = 'optimizer_mode';

"dt" <db2userNOdbSPAM_at_aol.com.invalid> wrote in message news:054b3ae4.c12b3b6c_at_usw-ex0104-031.remarq.com...
> Hi all, this might be a silly question.
> How does one tell what type of optimization
> is being used on the server, rule-based or
> cost-based?
>
> Thanks.
>
> David T.
Received on Wed Apr 26 2000 - 00:00:00 CDT