What is rule base and cost base optimizer?
Answer Posted / 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 View All Answers
What is execute immediate?
Explain polymorphism in pl/sql.
What is sqlcontext?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is dynamic sql in pl sql?
what is bcp? When does it used? : Sql dba
What are inner outer left and right joins in sql?
what is self join and what is the requirement of self join? : Sql dba
Is sql workbench free?
How do I run a script in sql developer?
What is having clause in sql?
Can I call a procedure inside a function?
when MSQL8.0 is in market
what is the difference between char_length and length? : Sql dba