Re: Explain Plan for queries
If you are on 9.40 you can set the dynamic explain for the session and get
the plans for the queries. U need to activate it using onmode -Y command.
But, if you are not on 9.40 .. u will need to run the queries seperately
from dbaccess to get the plans.
HTH
Thanx much,
Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
Fan Ruo Xin
<fanruox@sbcgloba To: informix-list@iiug.org
l.net> cc:
Sent by: Subject: Re: Explain Plan for queries
owner-informix-li
st@iiug.org
10/25/2003 08:31
AM
Please respond to
Fan Ruo Xin
Obnoxio The Clown wrote:
> > 2. As I mentioned I need to obtain query plans for multiple
> > queries. Is there a way to run a whole file having all these
> > queries using DBACCESS?
>
> Yes. Edit a file to contain:
>
> SET EXPLAIN ON;> SELECT ...;
> SELECT ...;
> SELECT ...;
>
Is there a way I can capture the access plans for all the sql stmts written
in
a java (JDBC) application?
sending to informix-list