Re: Optimization

From: <michael_bialik_at_my-deja.com>
Date: 2000/04/26
Message-ID: <8e7ech$m8r$1@nnrp1.deja.com>#1/1

Hi.

Make a
"SELECT owner, table_name FROM all_tables WHERE num_rows IS NOT NULL;"
If nothing selected then you are already working with RBO. Otherwise execute
"ANALYZE TABLE <owner>.<tb_name> DELETE STATISTICS;" for all selected tables.

HTH. Michael.

In article <07da195e.c72c417a_at_usw-ex0104-031.remarq.com>, dt <db2userNOdbSPAM_at_aol.com.invalid> wrote:
> Thanks Rob. I tried that query in SQLPLUS,
> it came back as "CHOOSE". How do I set it
> to rule-based?
>
> 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!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 26 2000 - 00:00:00 CDT