What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
No Answer is Posted For this Question
Be the First to Post Answer
How to drop a stored function?
Explain view?
How to execute the package in oracle?
Explain the different normalization forms?
How to convert a date to char in oracle? Give one example.
Can objects of the same Schema reside in different tablespaces.?
What is an Oracle index?
What is the best way to do multi-row insert in oracle?
How to retrieve data from an explicit cursor?
What is an anonymous block?
How do we switch from init.ora file to asp file?
How to sort the query output in oracle?