I am looking for a way to retrieve the "set explain on" results (usually
in sqexplain.out) without writing to the file. My sql statements are
executed via a cgi script and therefore, the user does not necessarily
have an account to write to.



Also, I have not been able to execute a prepared compound sql statment
that includes the "set explain on" statement followed by a select
statement. Any insights?

Ex: $sth = $dbh->prepare("set explain on;

select * from tablename where field < condition;

set explain off");

$sth->execute();


--
Posted via http://dbforums.com