What is the function of Optimizer ?
Answer / guest
The goal of the optimizer is to choose the most efficient
way to execute a SQL statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is a Synonym ?
Why do you create or replace procedures rather that drop and recreate.
What is a named program unit?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What are the components of Physical database structure of Oracle Database?
How would you optimize a slow SQL query?
what is the difference between oracle enterprise edition and oracle express edition?
how to retrieve daily sal from emp table in oracle 10g
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What is raw datatype in oracle?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?