Re: Optimization

From: Buck Turgidson <idontlikespam_jcman_at_worldnet.att.net>
Date: 2000/04/29
Message-ID: <b0zO4.40049$WF.2026817@bgtnsc04-news.ops.worldnet.att.net>#1/1

Just because it is "choose" doesn't necessarily mean it's running in cost. Look at DBA_TABLES and make sure you have statistics in them. Also, ask your DBA if he's regularly analyzing the database.

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.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Sat Apr 29 2000 - 00:00:00 CDT