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

Previous QuestionNext Question
ou want to group the following set of select returns, what can you group on? Max(sum_of_cost), min(sum_of_cost), count(item_no), item_no?You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done?