SQL Plan Management in Informix

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.