How Can You Force The Optimizer To Use A Particular Index?

1.	How Can You Force The Optimizer To Use A Particular Index?
Answer» USE HINTS /+ /, these ACTS as DIRECTIVES to the OPTIMIZER. Use hints /+ /, these acts as directives to the optimizer.

Answer»

Use hints /*+ */, these acts as directives to the optimizer.

Discussion