What is COST-based approach to optimization ?

Answer Posted / nishi

oracle generate the execution plan to the available statistics.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between pre-select and pre-query?

621


Explain oracle 12c new features for developers?

540


What is the disadvantage of User defind function?

1833


How view is different from a table?

557


What do database buffers contain?

565






Differentiate between post-database commit and post-form commit?

544


What are the different types of synonyms?

596


Describe the types of sub query?

555


What is the usage of synonyms?

590


Why is oracle database so popular?

566


Is oracle an open source?

638


How to use "for" statements in oracle?

594


How to define and use table alias names in oracle?

509


How to execute the package in oracle?

571


What is a package ? What are the advantages of package ?

604