What is RULE-based approach to optimization ?
Answer / kalyani
Rule Based Optimizer (RBO) - This method is used if the
server has no internal statistics relating to the objects
referenced by the statement. This method is no longer
favoured by Oracle and will be desupported in future
releases
| Is This Answer Correct ? | 2 Yes | 0 No |
Where do we use decode and case statements?
How do you store pictures in a database?
Explain joins in oracle?
What happens if you use a wrong connect identifier?
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?
How to restrict the duplicate records in table valuesets
Can a formula column referred to columns in higher group ?
What are a cluster and non-cluster index?
What are the oracle differences between nvl and coalesce
How do you handle duplicate records in a database?
Explain the use of grant option in exp command.
How to create index-by table in oracle?