Why would you want to override automatic query optimization?
What will be an ideal response?
Sometimes, the query designer may know information that can be overlooked by the query optimizer. Often, in the course of testing queries, one may find that it is actually faster not to use a certain index or to use a different index. When this is the case, database management systems such as Oracle include a facility to override the query optimizer, called query hints.
You might also like to view...
Negative gaps in perceived service quality can be remedied by lowering customer expectations
Indicate whether the statement is true or false
Trend analysis is an attempt to discern a trend between early and late respondents
Indicate whether the statement is true or false
Regression analysis can be performed using one or more activities to predict costs
Indicate whether the statement is true or false
How important do you think mentors are to learning leadership skills? What type of leadership skills do you think are best learned from mentors, and what type do you think are best learned from formal education?
What will be an ideal response?