create index ...
select .... order by ..
select distinct ...
select .... group by
select ...union
select ...intersect
select ...minus
unindex join,subquery
以上操作都有可能会使用temp segment
order by ,group by ,distinct 有可能会使用两个temp segment.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-1063834/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-1063834/