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

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 do you mean by a deadlock?

0 Answers  


can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,


How to assign data of the deleted row to variables?

0 Answers  


Explain how you would restore a database using RMAN to Point in Time?

0 Answers  


How to use select statement to count the number of rows in oracle?

0 Answers  






In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,


How to select some rows from a table in oracle?

0 Answers  


What is a Schema ?

6 Answers  


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

0 Answers   Wipro,


How to export several tables together?

0 Answers  


What is oracle database 10g express edition?

0 Answers  


Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,


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