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 is meant by redo log buffer ?
how to see the data (in unix) using dataset in datastage?
How to define a data source name (dsn) in odbc manager?
What is where clause in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is oracle data type?
What is RULE-based approach to optimization ?
Explain the use of file option in exp command.
How to recover a dropped index?
What is an oracle transaction?
what is the use of ondelete cascade?
Explain parameter file in oracle.