Answer Posted / mkjmkumar
Oracle Analyse a Query using two Approches
1. CBO
2. RBO
Cost Based Analyser is default when we do not in oracle
setup.
CBO picks up query output using witch have less cost
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is primefaces used for?
Explain the use of rows option in exp command.
Will you be able to store pictures in the database?
List out the components of logical database structure of oracle database.
Where do you use decode and case statements?
How to get last row id?
Explain the features of oracle?
What is the difference between I and G in Oracle?
What is the disadvantage of User defind function?
What is index-organized table in Oracle?
what is the scripts in data base?
How can Oracle users be audited?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
When do I need to use a semicolon vs a slash in oracle sql?
Explain self joins in oracle?
