會引起排序的sql語句型別!

warehouse發表於2009-05-04
閒的無聊,看看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.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19602/viewspace-1021643/,如需轉載,請註明出處,否則將追究法律責任。

相關文章