Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Unanswered: explain on informix 7.3

    Hello,

    Please, I need to do an explain of a SQL, as I can make this in the informix (7,3).

    Thank you very much

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Do you want to do an explain of the access path of an sql-qry?

    just use the sql statement:
    SET EXPLAIN ON;
    and
    SET EXPLAIN OFF;

    Informix will show exactly what the access path/joins/sorts/costs are

    On WinNT/W2K, you find the result in %INFORMIXDIR%\sqexpl
    On Unix, it's the directory where you executed dbaccess, or if you go via odbc, it's the homedirectory of the user.

    I hope I understood your question correctly.
    rws

  3. #3
    Join Date
    Sep 2002
    Location
    Pakistan
    Posts
    17

    Re: explain on informix 7.3

    I am bit confused about the question but I think this could be one answere.

    Using dbaccess or telnet do the following when writing quiries.

    -----------------------------------------

    set explain on;
    select * from from table_name

    -------------------------------------------

    This will create a file name sqexplain.out at the root

    editing this file will have the required results.
    Istikhar Ahmad
    ------------------
    Tel: (92-42) 111000911
    iahmad@i2cinc.com
    http://www.i2cinc.com

Posting Permissions

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