What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
Answer Posted / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to declare a local variable?
How to define a data source name (dsn) in odbc manager?
How to rename an index?
What is a dead lock in oracle?
How to view the tablespaces in the current database?
query optmization techniques and quwry analyser+projects+ppts
Write a trigger example in oracle?
Explain a data segment?
What is columnar storage what is the advantage?
Explain what are the different type of segments?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is ordinary table in oracle?
How to define a record variable to store a table row?
what is the dual table in oracle?
How to get a list of all user accounts in the database?