Interested to Buy Any Domain ? << Click Here >> for more details...
explain the purpose of optimizer directives and how/why you would use them
- 1 Answers
- 84 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / Prince Bhatia
Optimizer Directives are special SQL statements used to guide Informix's query optimizer in choosing the best execution plan for a given query. They can be used to override default optimization decisions or force specific operators to be used. For example, the 'FORCE INDEX' directive enforces the use of a specific index to improve performance, while the 'WITH (NO PUSHDOWN)' directive prevents certain operations from being pushed down to the storage engine for better control over resource utilization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
