What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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 |
Please explan Why static query is more faster than dynamic query ?
What is the max number of columns in an oracle table?
Explain how you would restore a database using RMAN to Point in Time?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
What is oracle server autotrace in oracle?
what is IDE,DMV in sql server?
Does oracle partitioning improve performance?
What is a Database instance ? Explain?
What is the difference between SQL and SQL Server?
How to drop an existing table in oracle?
What is pragma autonomous transaction in oracle?
How to create index-by table in oracle?