What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?



What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the A..

Answer / guest

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

More Oracle General Interview Questions

Please explan Why static query is more faster than dynamic query ?

2 Answers  


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

0 Answers  


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

0 Answers  


How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,


What is oracle server autotrace in oracle?

0 Answers  


what is IDE,DMV in sql server?

0 Answers  


Does oracle partitioning improve performance?

0 Answers  


What is a Database instance ? Explain?

3 Answers  


What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,


How to drop an existing table in oracle?

0 Answers  


What is pragma autonomous transaction in oracle?

0 Answers  


How to create index-by table in oracle?

3 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)