1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is rule base and cost base optimizer?

Question Posted / akshay

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

What are all different types of collation sensitivity?

0 Answers  

Can a foreign key be a duplicate?

0 Answers  

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

Is record in oracle pl sql?

0 Answers  

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,




Write a query to find the names of users that begin with "um" in sql?

0 Answers  

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

How many levels can subqueries be nested in a FROM clause?

7 Answers  

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

what is difference between delete and truncate commands? : Sql dba

0 Answers  

Which join condition can be specified using on clause?

0 Answers  

How to create a menu in sqlplus or pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories