SQL Plan Management in Informix
Danny Ng asked whether Informix has SQL plan management like Oracle SQL baselines and whether a plan can be fixed for a statement. Benjamin Thompson said there is no equivalent; use query directives, added in client SQL or server-side via external directives. They restrict the optimiser rather than guarantee a plan. Danny thanked him.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Are there any SQL plan management like SQL Baseline in Oracle for Informix?
As there would be multiple execution plans for one SQL Text, can we fix specific execution plan for one SQL Text?
If you are looking for something exactly like Oracle SQL Query Baselines, there is no such feature. If your aim is to lock down a query plan you need to use query directives. I realise that directives do not necessarily guarantee a specific plan, just restrict the optimiser's freedom. Usually though this distinction is not a problem. Directives can either be added to your SQL at the client end or at the server end via the external directive feature. Ben.
Thanks for your reply.