Mark Thomas wrote:

> If I might throw out a feature request for discussion:
> 
> It appears to me that EXPLAIN cannot be used with a query 
> that returns a
> result set.  It sure would be nice if it could.  I remember 
> that Informix
> does this, and includes an estimated number of rows besides.

Perhaps there is a misunderstanding, but 
EXPLAIN SELECT ... FROM ...
is a select for a query returning a result set.
But as explain says: it will not actually return it, it will just tell
how this query would be handled if it was sent.

If you mean that we should return the expected number of result rows
besides the info we return now: we will discuss it.

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to