![]() ![]() In such a case, use hints to force the optimizer to use the optimal execution plan. Based on this information, you might be able to choose a more efficient execution plan than the optimizer. Hints provide a mechanism to direct the optimizer to choose a certain query execution plan based on the specific criteria.įor example, you might know that a certain index is more selective for certain queries. As an application designer, you might know information about your data that the optimizer does not know. Hints let you make decisions usually made by the optimizer. The chapter contains the following sections: This chapter explains how to use hints to force various approaches. Optimizer hints can be used with SQL statements to alter execution plans.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |