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
What are a cluster and non-cluster index?
Explain about your project and its relation to the current job position you are applying to?
How to use null as conditions in oracle?
What is the difference between sharding and replication?
How to count groups returned with the group by clause in oracle?
What is an oracle wallet?
How to estimate disk space needed for an export job?
Explain the characteristics of oracle dba?
How to check your oracle database 10g xe installation?
How to count duplicated values in a column in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is rich query?
How are extents allocated to a segment?
What is an oracle user role?
Can we save images in a database and if yes, how?