Script" References MACLEAN‘s post Speed up the index creation.

最新推荐文章于 2021-04-03 04:37:41 发布

weixin_30315435

最新推荐文章于 2021-04-03 04:37:41 发布

阅读量67

点赞数

原文链接：http://www.cnblogs.com/DataArt/p/10018135.html

版权

alter session set workarea_size_policy=MANUAL;
alter session set db_file_multiblock_read_count=512;
alter session set events '10351 trace name context forever, level 128';
alter session set sort_area_size=734003200;
alter session set "_sort_multiblock_read_count"=128;
alter session enable parallel ddl;
alter session set db_file_multiblock_read_count=512;
alter session set db_file_multiblock_read_count=512;
alter session set "_sort_multiblock_read_count"=128;
alter session set "_sort_multiblock_read_count"=128;

spool create_index.log
@create_index.sql
spool off

转载于:https://www.cnblogs.com/DataArt/p/10018135.html