找一下常见的要求排序的操作。如果在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博客 ” ,链接:https://blog.itpub.net/29987/viewspace-51892/
,如需转载,请注明出处,否则将追究法律责任。