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 is the function of Optimizer ?

Answer Posted / guest

The goal of the optimizer is to choose the most efficient
way to execute a SQL statement.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I manually create a database in oracle?

1068


In what script is snap$ created? In what script is the scott/tiger schema created?

2758


What is null value in oracle?

1157


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

2252


How a database is related to tablespaces?

1081


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1890


How will you write a query to get a 5th rank student from a table student_report?

1918


What are the uses of a database trigger?

1035


How to write a query with a right outer join in oracle?

1219


What is Virtual Private Database in Oracle?

1147


What is the difference between count (*), count (expression), count (distinct expression)?

1046


Please explain compound trigger in oracle?

1107


Explain view?

1085


How to use subqueries with the in operator using oracle?

1137


IS it possible to built the oracle database without setting the kernal parameters?

2393