What is COST-based approach to optimization ?

Answer Posted / mahesh

For running any quey requires or generates an execution pan
before actually fetching data

in cost based approach, the oracle will generates the
execution plan based on available statistics.

oracle supports cost based approcach and it is continuously
improving fron one version to another version of oralce
database

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by group by clause?

569


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1971


Explain table?

668


How to create an initialization parameter file?

548


interview questions with answer for cts

2096






How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1477


What is tns entry?

636


Is oracle an open source?

644


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

550


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1625


What is oracle sid?

514


How to generate query output in html format?

575


Explain about integrity constraint?

617


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1959


How to load data from external tables to regular tables?

553