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
How to create a new view in oracle?
What is a view and how is it different from a table?
What is using clause and give example?
Explain implicit cursor.
What is a server parameter file in oracle?
What are the types of trigger in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is an oracle and why it is used?
How to get a list of all user accounts in the database?
In oracle there is column command, how will you explain that?
What are the major difference between truncate and delete?
How to add a new column to an existing table in oracle?
What are operators in oracle?
What is a parameter file in oracle?
Can we store pictures in the database and if so, how it can be done?
