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...
A(n) ________ is a new product that copies, with slight modification, the design of an original product
A) augmented product B) discontinuous innovation C) dynamically continuous innovation D) continuous innovation E) knockoff
Which of the following statements is true of the Equal Protection Clause of the U.S. Constitution?
A) It is included in the Fourth Amendment. B) It prohibits discrimination based on sufficient justification. C) Intermediate scrutiny is applied when the classification is based on race, color, or national origin. D) The rational basis test is applied when there is no class-based suspect classification.