What is the function of Optimizer ?



What is the function of Optimizer ?..

Answer / 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

More Oracle General Interview Questions

What is the usage of synonyms?

0 Answers  


What is the difference between PFILE and SPFILE in Oracle?

0 Answers   MCN Solutions,


What do database buffers contain?

0 Answers  


How to define an anonymous block?

0 Answers  


How to define a record variable to store a table row?

0 Answers  


what is query and types of query

6 Answers   Reliance,


How to retrieve 5th highest sal from emp table?

8 Answers  


T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,


What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  


how to make an oracle object

0 Answers  


sql command 2 know current database

4 Answers  


How to use attributes of the implicit cursor in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)