What is COST-based approach to optimization?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

188. What is COST-based approach to optimization?

Considering available access paths and determining the most efficient execution plan based on statistics in the data dictionary for the tables accessed by the statement and their associated clusters and indexes.

(Continued on next question...)

Other Job Interview Questions

• What is the diff. when confine mode is on and when it is off?
• What are the different modals of windows?
• What are parameters?
• If you see contention for library caches how can you fix it?
• How can a cross product be created?
• You have just compiled a PL/SQL package but got errors, how would you view the errors?
• How can a button be used in a report to give a drill down facility?
• Can a formula column referred to columns in higher group?
• What is a timer?
• How do you add a data file to a tablespace?
• More...