Long Queries and the Art of Full Scan
October 21–24
Level: Intermediate
Some queries just can’t run in a fraction of a second, no matter how well-written. This does not mean they cannot be optimized. Many practitioners hold that since analytical reports do not have strict response time requirements, it is not important how fast or slow they run. What's a big deal if a query only runs once a day, or once a week, or once a month? This is a dangerous practice. If report performance is neglected, performance can easily degrade from minutes to hours or even days! Let's learn how to be proactive and build reports the right way from the start, so that they won't become a performance disaster when the data volumes increase!