找一下常见的要求排序的操作。如果在Memory中不能完成则需用在Temp Tablespace来完成
–
1.Index creation
–
2.Parallel insert operation involving index maintenance
–
3.ORDER BY or GROUP BY clauses
–
4.DISTINCT values selection
–
5.UNION, INTERSECT, or MINUS operators
–
6.Sort-merge joins
–
7.ANALYZE command execution
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51892/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29987/viewspace-51892/