Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.