Re: How to optimize query's execution?

From: MBPP <mpacheco_at_directnet.com.br>
Date: 1 Sep 2005 05:42:36 -0700
Message-ID: <1125578556.808318.215600@g43g2000cwa.googlegroups.com>

Based on the plan above the tables are not analyzed and the "rule" optimizer is being used, not the "cost" one. Analyze the tables and try again.

execute dbms_stats.gather_table_stats(user,'MY_KEYS') execute dbms_stats.gather_table_stats(user,'MY_JSTATE')

The above form of analyzing a table is very basic, take a look at the manual "Supplied PL/SQL Packages and Types Reference" for all available options and parameters. The "Concepts" manual is also good to learn about different types of optimizers, statistics, etc. Received on Thu Sep 01 2005 - 07:42:36 CDT