On Sun, 2002-09-15 at 12:20, Stephan Szabo wrote:
> The one in this case is probably the smallint/bigint problem with
> constants being converted to int4 when unquoted.
> Try client='10143' or client=CAST(10143 as smallint) in the where
> clauses instead of client=10143 and see if that gives you usage of the
> index.
Brilliant, got it in one.
Thanks.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015