Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?

Question Posted / guest

Answer Posted / guest

This value causes the optimizer to choose the rule_based
approach for all SQL statements issued to the instance
regardless of the presence of statistics.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

When do you get a .pll extension in oracle? Explain its importance

1042

What are the various types of snapshots ?

1029

In which language oracle has been developed?

1075

What is a Garbage Collection? and what is full recursive Garbage collection?

2905

What is an oracle user role?

984

How to drop an index in oracle?

1076

Explain oracle instance.

1180

What is an oracle transaction?

1146

Explain the use of ignore option in imp command.

1035

How to create lov dynamically at runtime & attach to text field?

1200

what is the difference between data migration and production migration.

2346

How can we find out the current date and time in oracle?

1090

What do you mean by redo log file mirroring?

1032

What is a sub query and what are the different types of subqueries?

1125