Re: DB performance : 45 seconds for a query ?

Posted in 1998

Igor Belianski — Wed, 23 Dec 1998 15:56:40 -0500 — source: Informix-list mailing list archive (1991-1998)

Sean Kelsey wrote in message <3680e843.0@145.227.194.253>... >What do you get if you ( cross an elephant with a giraffe ?? ) run UPDATE >STATISTICS on the tables ?? > >Do you have any referential integrity or constraints on any of the tables ?? > >Sean > I am not sure, but as far as I understand referential constraints can not slow down SELECT statement (only updates, inserts , load ,.... )