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
Explain the blob datatype?
List out the components of logical database structure of oracle database.
What is a snapshot in oracle database?
How to list all indexes in your schema?
How to install oracle database 10g xe?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
defination of bitmap index
What are group functions in oracle?
What is varray?
How to upsert (update or insert into a table)?
How to retrieve the count of updated rows?
How to set up autotrace for a user account?
What is an oracle and why it is used?
Will you be able to store pictures in the database?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.