DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: How to know the optimizer mode for an SQL statement.

Threaded View

  1. 03-03-2003, 01:01 AM #2
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: How to know the optimizer mode for an SQL statement.

    Originally posted by V6163

    3. Out of 700 tables in my database, I have analyzed only 10 tables, which are the main tables.
    You have to analyze all USER tables and indexes in your database. You can do this using
    Code:
    execute dbms_utility.analyze_schema('SCHEMA_NAME', 'COMPUTE');
    This will enable the database engine when using the COST based optimizer to get accurate statistics to choose the best plan. This is with reference to what you mentioned about the Cost based optimizer being used when even one table is analyzed in a query (All tables in the query must be analyzed).

    HTH.
    Last edited by ggnanaraj; 03-03-2003 at 01:06 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width