Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimization

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US