Re: 245 Could not position within a file via an index

Posted in 1996

Martin Berns — Mon, 04 Nov 1996 11:43:14 +0100 — source: Informix-list mailing list archive (1991-1998)

Allan Gould wrote: > Has anyone got any idea why I might get this error from a stored procedure > when I execute it, yet when I execute the query "hands-on" it runs fine?? Hi Allan, perhaps you created the Stored Procedure on the empty base, so Informix-Optimizer decides to do a sequential scan. Try (if You didn't already) update statistics for procedure "allang".allangsub1;hth martin