We had a strange problem with Sybase performance: the query that should have used indexes while executing did not, and as a result took forever to execute. For some reason the time stamp was not treated as date type when set from the code. So the easiest solution was to add ?DYNAMIC_PREPARE=true to the connection string, and that solved the problem.