Hello everyone, I have a particular table that is the heart of our applications. As a result most of the select statements, stored procedures and views involve this table. We have indexed it adequately. All the procs on this table seem to be running fine except for a Delete procedure that deletes one line from the table (we pass the ID to this proc). This procedure times out even when I set the time-out interval to 10 minutes. Is there anything special I can do to fix this (re-index, remove index, etc.)?
Any help would be greatly appreciated.
Nick
Any help would be greatly appreciated.
Nick