闲的无聊,看看9i 的性能优化ocp考试题,题中提到了的一点内容,记得在doc上也看到过,不过从10g开始,group by不一定会排序。[@more@]The types of SQL statements that can cause database sorts to occur include the following: ORDER BY,
GROUP BY, SELECT DISTINCT, UNION, INTERSECT, MINUS, ANALYZE, CREATE INDEX, joins
between tables on columns that are not indexed.
GROUP BY, SELECT DISTINCT, UNION, INTERSECT, MINUS, ANALYZE, CREATE INDEX, joins
between tables on columns that are not indexed.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1021643/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1021643/