Does informix allow you to look at a query execution plan for tuning and if so can someone tell me how? I see no mention in the SQL ref 1&2. Also, MS-SQL has some tools that allow the server to analyse a query and suggest indexes and other improvements...is there an analagous feature (or product) for informix?

To quote sundialsvcs (another forum member) I have some programmers who have written some cucamunga queries that could use some tuning!

Yes - use SET EXPLAIN ON;