Re: HELP : Informix and Delphi

Posted in 1997

Kerry Sainsbury — Mon, 10 Mar 1997 01:01:37 -0500 — source: Informix-list mailing list archive (1991-1998)

In article <331CBC9A.3712@link.com.au>, Adam Sorati <asorati@link.com.au> wrote: >Delphi 2.01 >Informix SE ver 5 > >I have to same problem. > >The time delay only seems to occur when I use a parameter. >When I build the SQL code I do not have this problem. >Does anyone have any idea why this whould cause a problem. Somehow Informix decides to do a sequential scan rather than use an index. (Do a "SET EXPLAIN ON" to see this). I guess I should raise this as a bug with Informix. I've already raised it with Borland. It would be great if you did too! Cheers, Kerry S