We have some stored procedures that have been running with 7.0.16 for quite some time. With 7.1.6 the same procedures are being used and they take forever to run. It appeares the "Select into" statements in the stored procedures are now ignoring the indexes and are doing complete table scans. We have a SQL script that assigns values to local variables and runs a SELECT statement based on the variables, this takes 1.5 miniutes to return. When the variables are replaced with actual values it only takes 1 second to return. This did not happen with 7.0.16. Does anyone have a clue as to what is going on? Received on Wed Aug 30 1995 - 00:00:00 CEST
Original text of this message