SQL Tuning

From: Samuel <seatechk_at_iohk.com>
Date: 2000/02/17
Message-ID: <38ab9f03@news.iohk.com>#1/1

Hi! Can anyone give me some advices for tuning sql?

I am using the explain plan to fine tune my designed sqls. The optimizer mode of my database is in CHOOSE base.

The first it showed me that the cost value of the explain plan is null. It means that it used RBO. Then I try to give a all rows hint to this sql and re-create the explain plan. Now it showed me the cost value is 2490.

How can I determine which one provide better performance?

Many thanks

Samuel Received on Thu Feb 17 2000 - 00:00:00 CST