Re: Sybase 11 to 12 upgrade - SQR performance problems

[Christopher Wanko <WankoC@LABS.WYETH.COM>]

>>> abe.crabtree@CITICORP.COM 02/05 10:50 AM >>>
Some of our reports run slower on Sybase v12.  I believe it is because Sybase
12 is more fussy about when it will use an index.  If the left hand and right
hand side of a WHERE are different types (INT/SMALLINT, or different size of
NUMERIC,) then an index may not be used.

That sounds like normal behavior for Sybase, or any SQL-compliant db.  You 
can't ask the db to automatically convert objects to the index datatype; 
indeed, using convert is the best way to ensure the index is used.

If you can't code the convert statement in your SQR, then you can use a stored 
proc to run your SQL code.

-Christopher