Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Unanswered: qry execution plan / ananlysis

    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!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Yes - use SET EXPLAIN ON;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •