Ideal Ordeal? Deal.

to break is human; to fix is also human

Posts Tagged ‘Index’

Performance Pain: To LIKE or not to LIKE

Posted by Raj Kashyap on Wednesday, November 24, 2010

We have agonized over excruciating SQL performance pains. Some of them defy elegant solution. Some don’t seem to go away, like a persistent migraine. Sometimes, the problem is a specific type of query that is always slow. This type of query is typically used in stored procedures, executed by several applications and batch processes. The performance seems to get drastically degraded as the table grows over time. Oddly, it has worked fine for some time in the past and nothing in the SQL itself has changed. Moreover, it is always fast when embedded in front-end applications. So, why is it slow when it is in a stored procedure? more…


Posted in Programming | Tagged: , , , , , | Leave a Comment »