What are the different approaches used by Optimizer in choosing an execution p

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 different approaches used by Optimizer in
choosing an execution plan ?

Question Posted / guest

2 Answers
5296 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the different approaches used by Optimizer in choosing an execution plan ?..

Answer / guest

Rule-based and Cost-based

Is This Answer Correct ?

2 Yes

0 No

What are the different approaches used by Optimizer in choosing an execution plan ?..

Answer / nishi

Rule-based and Cost-based.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What are the values that can be specified for OPTIMIZER MODE Parameter ?

What is the max number of columns in an oracle table?

What is the difference between substr and instr?

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Can a primary key contain more than one columns?

what is cartesian product?

How does oracle handle read consistency?

Can you have more than one content canvas view attached with a window ?

0 Answers Oracle,

what is the scenario where you take the database to NoArchivelog mode?

What are the limitations of check constraint?

Describe varray?

Explain what are clusters?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)