Re: SET EXPLAIN - why are INSERT costs high???

Posted in 1998

SailF3 — 26 Feb 1998 05:41:00 GMT — source: Informix-list mailing list archive (1991-1998)

I agree. In general, the "cost" in an sqexplain.out is crap. I've seen the best query plan imaginable, with a really bad cost. Bottom line, learn your schema and data distribution to know how to write a good query. Sean Bradley