What is rule base and cost base optimizer?

Question Posted / akshay

2 Answers
7397 Views
Thermotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is rule base and cost base optimizer?..

Answer / chandra shekher

Rule based optimiser will optimise the query based on the
rules.

Cost based optimiser will optimise the query based on the
statistics available for the table.

Is This Answer Correct ?

4 Yes

1 No

What is rule base and cost base optimizer?..

Answer / chandra bhusan prasad

one is supported in 8i and another in 9i/10g
cost base optimizer display the cost attributes of query
and it is easier.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More SQL PLSQL Interview Questions

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers Satyam,

What is the difference between function, procedure and package in pl/sql?

0 Answers

What company owns postgresql?

0 Answers

How long will it take to learn pl sql?

0 Answers

How do we use distinct statement? What is its use?

0 Answers

Does pl/sql support create command?

0 Answers

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?