What are the values that can be specified for OPTIMIZER
MODE Parameter ?

Answer Posted / guest

COST and RULE

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to establish administrator authentication to the server?

556


What is the Tune Query

1837


What is data block in Oracle?

615


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1554


What is the simplest tool to run commands on oracle servers?

511






Explain an extent?

657


Explain a private synonyms?

629


What happens to the current transaction if a ddl statement is executed?

574


what is reindexing?

1171


How to connect to a remote server?

553


What is recovery manager(rman) backup in Oracle?

621


How to list all indexes in your schema?

577


What are nested tables?

668


What is rich query?

539


What is the data pump export utility?

639