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 create a single index for multiple columns?
Why do we use bulk collect in oracle?
Is oracle an operator?
What is a schema in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the difference between online and offline backups?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is Java Pool in Oracle?
How to assign data of the deleted row to variables?
What is raw datatype in oracle?
What are the different pseudo commands? Explain in general?
What is the recommended interval at which to run statspack snapshots, and why?
What is blob data type in oracle?
How many types of synonyms in Oracle?
Can we store pictures in the database and if so, how it can be done?