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 |
sql command 2 know current database
How can I create database in oracle?
Explain the features of oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
What is the difference between $oracle_base and $oracle_home?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is raw datatype in oracle?
what happened to the global index when I truncate the data in one of the partition?
Explain the use of owner option in exp command.
What do you mean by cdb and pdb in oracle 12c?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?