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 the usages of sql?

0 Answers  

how to insert the records in particular position

1 Answers  

What is the use of stored procedures?

0 Answers  

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

What is trigger point?

0 Answers  




What is the difference between delete and truncate commands?

0 Answers  

difference between oracle 8i and oracle 9i

8 Answers  

What if we write return in procedure?

0 Answers  

What is pseudo column ?

6 Answers   ABB,

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

What view means?

0 Answers  

what is self join and how it works??

2 Answers   Infosys,

For more SQL PLSQL Interview Questions Click Here
Categories