Re: Please explain why this query is slow.

Posted in 1996

Robin Cyrus — 16 Feb 1996 21:50:57 GMT — source: Informix-list mailing list archive (1991-1998)

Interesting one! Wild shot but her it is anyway: 'iscolor' having only two values has less to search and join than 'category' which has four possible values. why 'iscolor' sql is more expensive than 'category'!!!! I don't take the "cost result' from SET EXPLAIN too seriously...Informix say not to either. Robin Cyrus First Interstate Bank Phoenix AZ -- F. I. B. of Arizona