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

How do you retrieve the last N records from a table?

10 Answers  

What do you mean by stored procedures?

0 Answers  

how to drop an existing table in mysql? : Sql dba

0 Answers  

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

What are sql injection vulnerabilities?

0 Answers  




.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

What are two parts of package ?

2 Answers   Infosys,

Can we call procedure in select statement?

0 Answers  

Can we alter stored procedure?

0 Answers  

What is bulk collections?

2 Answers  

How is a process of pl/sql compiled?

0 Answers  

What is a column in a table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories