In order to optimize queries,some DBMSs allow the programmer to use hints that influence the access plan,but these should be used cautiously because a hint will override the optimizer.

Question

Quizplus · Accepted Answer

Hints may be useful in optimizing queries, but they should be used cautiously because they override the optimizer, which may lead to inefficient execution plans.

In Order to Optimize Queries,some DBMSs Allow the Programmer to Use