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...

What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?

Answer Posted / nishi

This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between number and binary_float in oracle?

1100


How to execute a stored procedure in oracle?

1091


What is oracle in java?

969


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5551


List the types of joins used in writing subqueries?

996


Explain the use of file option in exp command.

1129


How many categories of data types in oracle?

1029


What is the difference between pre-select and pre-query?

1218


What is the exact use of Collections?

2143


What is set operator oracle?

978


Briefly explain what is literal? Give an example where it can be used?

1042


What is a read only transaction in oracle?

1029


How to find out what oracle odbc drivers are installed?

1040


Explain index?

1258


What is an oracle transaction?

1146