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 |
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
what is integrity constrains?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
How to set a transaction to be read only in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
What is oracle and what are its different editions?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
What is an oracle user account?
How to recover a dropped table in oracle?
How to experiment a data lock in oracle?
query optmization techniques and quwry analyser+projects+ppts