在优化sql时一般遵循什么原则？

farshow · 发表于 2001-10-18 19:59

限制越严格的条件越靠后

felixch · 发表于 2001-10-23 13:13

先看oracle 手册，这个话题太大了

sz1999 · 发表于 2001-10-26 05:43

From developer point of view, knowing your data is No 1 important including table structure and application ERD, data volumn and its cardinality, then should know how to control index usage, join order, and colleteral subqury etc coding techniques, don't rely on using HINT on lousy query.