基于案例的sql优化

[{"title":"（ 31 个子文件 5.74MB ） 基于案例的sql优化","children":[{"title":"基于案例学SQL优化第1周脚本","children":[{"title":"5. 忽略SQL改造等价性","children":[{"title":"你眼中只有快吗.sql <span style='color:#111;'> 375B </span>","children":null,"spread":false},{"title":"max min优化引发的探讨.sql <span style='color:#111;'> 466B </span>","children":null,"spread":false},{"title":"in与范围写法.sql <span style='color:#111;'> 2.11KB </span>","children":null,"spread":false},{"title":"看似不等，其实相等.sql <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false},{"title":"insert all.sql <span style='color:#111;'> 774B </span>","children":null,"spread":false}],"spread":true},{"title":"1. 缺乏对讹传的辨知力","children":[{"title":"count各列性能统计.xlsx <span style='color:#111;'> 11.74KB </span>","children":null,"spread":false},{"title":"表的连接顺序.sql <span style='color:#111;'> 999B </span>","children":null,"spread":false},{"title":"终于明白count谁快.sql <span style='color:#111;'> 1.97KB </span>","children":null,"spread":false},{"title":"表的条件顺序.sql <span style='color:#111;'> 768B </span>","children":null,"spread":false},{"title":"in与exists之争(10g).sql <span style='color:#111;'> 621B </span>","children":null,"spread":false},{"title":"in与exists之争(11g).sql <span style='color:#111;'> 650B </span>","children":null,"spread":false},{"title":"count哪种写法更快.sql <span style='color:#111;'> 983B </span>","children":null,"spread":false}],"spread":true},{"title":"4. 未考虑将需求最小化","children":[{"title":"需求最小化.sql <span style='color:#111;'> 9.78KB </span>","children":null,"spread":false}],"spread":true},{"title":"3. 不会依据场景选技术","children":[{"title":"分区效率变低.sql <span style='color:#111;'> 1.87KB </span>","children":null,"spread":false},{"title":"从单车到飞船的SQL优化之旅.ppt <span style='color:#111;'> 6.29MB </span>","children":null,"spread":false},{"title":"索引与排序.sql <span style='color:#111;'> 431B </span>","children":null,"spread":false},{"title":"条数性能大比拼.sql <span style='color:#111;'> 2.10KB </span>","children":null,"spread":false},{"title":"索引与更新.sql <span style='color:#111;'> 2.06KB </span>","children":null,"spread":false}],"spread":true},{"title":"2. 不具备少做事的意识","children":[{"title":"全局临时表特性.sql <span style='color:#111;'> 1.85KB </span>","children":null,"spread":false},{"title":"视图研究.sql <span style='color:#111;'> 934B </span>","children":null,"spread":false},{"title":"不回表.sql <span style='color:#111;'> 272B </span>","children":null,"spread":false},{"title":"集合写法.sql <span style='color:#111;'> 486B </span>","children":null,"spread":false},{"title":"GROUP BY 的合并.sql <span style='color:#111;'> 13.81KB </span>","children":null,"spread":false},{"title":"分区清理.sql <span style='color:#111;'> 3.47KB </span>","children":null,"spread":false},{"title":"CASE WHEN改造.sql <span style='color:#111;'> 57.80KB </span>","children":null,"spread":false},{"title":"分区消除.sql <span style='color:#111;'> 2.98KB </span>","children":null,"spread":false},{"title":"避免SQL中的函数调用.sql <span style='color:#111;'> 2.23KB </span>","children":null,"spread":false},{"title":"表连接中多余列的影响.sql <span style='color:#111;'> 1.24KB </span>","children":null,"spread":false},{"title":"让人怀疑自己眼睛的SQL.sql <span style='color:#111;'> 8.64KB </span>","children":null,"spread":false},{"title":"减少SQL中的函数调用.sql <span style='color:#111;'> 2.08KB </span>","children":null,"spread":false}],"spread":false},{"title":"6. 不识需求乃顶级优化","children":[{"title":"暂无脚本.txt <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]