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 are the factors that affect OPTIMIZER in choosing an
Optimization approach ?

Question Posted / guest

Answer Posted / guest

The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the major difference between truncate and delete?

984

What are the extensions used by oracle reports?

998

Explain the function of optimizer in oracle?

1056

What is the fastest query method to fetch data from the table?

1295

What is coalesce function?

1009

Explain the use of file option in exp command.

1081

Difference between pre-select and pre-query

1031

What is a server parameter file in oracle?

1004

How to assign query results to variables?

1013

what are the advantages of running a database in archive log mode?

2144

What privilege is needed for a user to insert rows to tables in another schema?

957

Does oracle charge for java?

1008

Can we insert data in view oracle?

963

Can we save images in a database and if yes, how?

1002

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1986