Latest articles under General SQL category

Optimizing SQL that selects the max/min/etc from a group.

How would you like to optimize a 10 minute query down to 24 seconds? This was an optimization I had to do at work and I thought I’d share this with anyone. Even though I was using MySQL as an example, I think the technique should work on any database. Let’s say you have a […]

Posted on January 8th, 2009 under General SQL  •  3 Comments

Page 2 of 212