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 retrive xml data for using sql query?
What operating systems are supported by oracle database 10g xe?
How to call a stored procedure inside a trigger? Give an example.
what is difference between DBMS and RDBMS?
Differentiate between pre-select and pre-query?
What is sequence?
How to use regular expression in pattern match conditions in oracle?
What is the fastest query method to fetch data from the table?
what happened to the global index when I truncate the data in one of the partition?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
When does a Transaction end ?
Explain the use of record option in exp command.