To "explain" a query, just issue

explain select * from MyTable where MyField = '123'

(just putting explain word ahead will give path used by optimizer)

Best regards,

Edson Richter


----- Original Message ----- 
From: "Nestor Rojas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 11:34 AM
Subject: set explain





hello list friends

i want know as it is implemented  set explain (informix) in sapdb to make
pursuit to a query

thanks

Nestor



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.486 / Virus Database: 284 - Release Date: 29/5/2003

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

Reply via email to