Re: Set explain utility

Posted in 1997

MarkDenham@aol.com — 15 Jun 1997 00:38:25 -0400 — source: Informix-list mailing list archive (1991-1998)

David, I would be surprised if they are generated by the prepare for the simple reason that the output contains details of the values used in filters (if my memory serves me correctly). If you prepare a query such as: SELECT * FROM orders WHERE customer_num = ? AND customer MATCHES ? The query cannot be optimised until the values are known since they influence the way the query is processed. I will of course check this! Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)