价值百万的it技术知识dwdata warehouse数据仓库基础tips.pdfVIP

Top Ten SQL Performance Tips By Sheryl M. Larsen Contents Top Ten SQL Performance Tips 3 Introduction 3 Overview3 Tip #1: Verify that the appropriate statistics are provided4 Tip #2: Promote Stage 2 Stage 1 Predicates if Possible5 Tip #3: SELECT only the columns needed 7 Tip #4: SELECT only the rows needed 7 Tip #5: Use constants and literals if the values will not change in the next 3 years (for static queries) 7