SQL (Structured Query Language) Question: Download Questions PDF
What special Oracle feature allows you to specify how the cost based system treats a SQL statement?
Answer:
The COST based system allows the use of HINTs to control the optimizer path selection. If they can give some example hints such as FIRST ROWS, ALL ROWS, USING INDEX, STAR, even better.
Download SQL Interview Questions And Answers
PDF