Re: Set explain utility

In article <33A2B945.4989@agcs.com>, Roger Tomas <tomasr@agcs.com> writes >MarkDenham@aol.com wrote: >> >> All >> >> I'm looking for a utility that I can use to run an SQL statement, with >> SET EXPLAIN ON.>> >> I want to be able to stop the program after the query profile has been >> analysed, >> before it has a chance to retrieve too much data from the database. >> >> Anybody got a utility like this? > >ME TOO! ME TOO! ME TOO! > >DEC's old Rdb/VMS product did this and it was real handy. >I'd also like to know about such a utility. > >By the way, could you get the same SET EXPLAIN results >if you wrote an ESQL/C program that does the following? > >- reads a SELECT statement from stdin >- executes a SET EXPLAIN ON statement >- PREPAREs the SELECT statement >- DECLAREs a cursor for the prepared SELECT >- OPENs the cursor >- exits > >I'm not sure if you'd get the same statistics and, if so, >whether they's come from the PREPARE, DECLARE or OPEN. > >----------- >Roger Tomas >AG Communication Systems They come from the prepare... so just prepare the cursor... -- David Williams