GeekInterview.com
Series: Subject: Topic:
Question: 21 of 33

What  is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

The  Optimizer  chooses  Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
Asked by: Interview Candidate | Asked on: Sep 6th, 2004

This Question is not yet answered!

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Describe a time when you had to convince a friend ?

What do you think about our company?

How do you deal and overcome major challenges?

What are the career options available in Software Testing Industry?

Importance of an MBA for an entrepreneur

Do you have any questions that you want to ask?

Tell me about a skill you recently acquired or improved.

Provide an example of a goal that you successfully attained.

Has there been a time when you were presented a problem and solved it?

What do you do when someone criticizes you?

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe