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 |
What are the restrictions in a oracle read only transaction?
Can a primary key contain more than one columns?
How to assign a table row to a record variable?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to display row numbers with the records?
Explain integrity constraints?
what is trigger?
material view and view disadvantages?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
How to enter a new row into a table interactively?
What is Hash Cluster ?
What are the factors causing the reparsing of SQL statements in SGA?