Re: Explain Plan for queries

Answers Embedded. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "ovkrishna" <member44474@dbforums.com> To: <informix-list@iiug.org> Sent: Thursday, October 16, 2003 12:31 PM Subject: Explain Plan for queries > > Hi, > > > > I have a bunch of issues, though mostly related to obtaining the query > plan in informix. I am working with version 9.30. > > I am a newbie to Informix online dynamic server. So my questions might > be too basic. Please be patient with me. > > > > I need to obtain the query plan for a set of queries and tune them. I am > using DBACCESS to run the queries. Going through the documents I came to > know that I can get the query plan by executing SET EXPLAIN ON and then > executing my queries. Now I have the following questions > > 1. Is there a way in INFORMIX as in ORACLE to obtain the query plan, > without actually executing the queries? If yes how? I believe there is now with 8.4, 9.4 may have done the same thing - it's been a while since I checked - in other words I don't know for sure. > > 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? put all your queries in a file (include the set explain on if you like) and then: dbaccess <database> file > > 3. All my queries are huge in size. So is there a mechanism to set the > SQL Edit buffer size in dbaccess, as I am getting a error "801: SQL > Edit buffer is full." Use vi instead of dbaccess, you can still run them. > > 4. As in Oracle SQLPLUS (set spool on), is there a way to redirect the > output to a file in Informix. > dbaccess <database> file.sql > output_file > > > Please clarify > > > -- > Posted via http://dbforums.com > sending to informix-list