Optimization

One byte at a time, obviously! No elephants were harmed during photoshopping. Sometimes, when you have to optimize a poor performing query, you may find yourself staring at a huge statement, wondering where to start. Some developers think that a single elephant statement is better than multiple small statements, but this is not always the case. Let’s try to look from the perspective of software quality: Efficiency The optimizer will likely come up with a suboptimal plan, giving up early on optimizations and transformations. [Read More]