hi guys, It's santhosh here,

[santhu0579]

1)What is the difference b/w Rule Based optimization and cost based optimization.?? ?

2) what is SQL Hints????

[frozenmist]

Hi Santosh,

Please give meaningful titles in future as the experts can view you question easily.

Moderator

[frozenmist]

Hi,
Answers in brief:

http://www.oracle.com/technology/oramag/oracle/05-jan/o15tech_tuning.html

This link, just gives a small explanation on your first question

Sql hints are like you are asking the query to do something in a particular way. You specify in the query to use a certain index etc:

eg: select /*+ index(scott.emp ix_emp) */ from scott.emp emp_alias

Cheers