set explain out

Posted in 2005

Topics: Versions, Editions & End-of-Life

PARAMESHWAR PATHRI — Fri, 04 Mar 2005 05:27:09 — source: IIUG Forums & Mailing Lists

Hi all, I am using IDS 9.3 version. I am getting a strange out put in set explain for the select queries. The set explain out shows scanning for all the fragments even though there is no fragmentation defined on the database. Also some of the conditions are not listed in the output. I also observed that the execution time is same even though the difference of cost between these queries is far greater. Bye.

↪ replying to PARAMESHWAR PATHRI

JOSE LUIS MATUTE — Fri, 04 Mar 2005 12:20:52 — source: IIUG Forums & Mailing Lists

Hi, 1) There's no difference if the fragmentation exists or not. It states that phrase. 2) The cost is just an indicator. It doesn't has anything to do with real query time

Glossary

IDS (Informix Dynamic Server)
fragmentation