I have a large recordset in MSQL5. I use a program I wrote to update records in the db. It has been working for a year now. All of a sudden on a simple query I am getting " the estimated cost of this query 31 exceeds the threshold of 30... Did you change the tresholds? Or, could it be because my table size has grown beyond a certain size? The query is a stored procedure that just takes the record number and updates a field in the associated record.
I need this to work, so any help would be appreciated.
Thanks
I need this to work, so any help would be appreciated.
Thanks