//下面的脚本可以用来计算FSFI值碎片：
select tablespace_name,sqrt(max(blocks)/sum(blocks))*
(100/sqrt(sqrt(count(blocks)))) FSFI
from dba_free_space
group by tablespace_name order by FSFI;
//重建表脚本
create table zhang.favour_menu_bak as select * from zhang.favour_menu ;
truncate table zhang.favour_menu ;
insert into zhang.favour_menu select * from favour.favour_menu ;
commit;
CREATE INDEX "TX_TEST"."PK_DETAIL_ACC_ITEM_2"
ON "TX_TEST"."DETAIL_ACC_ITEM"("CYCLE_ID", "ACCOUNT_ID")
TABLESPACE "BA_INDEX_6";
//建索引脚本
CREATE INDEX "IUTBS"."PK_DETAIL_ACC_2"
ON "IUTBS"."DETAIL_ACC_ITEM"("CYCLE_ID", "ACCOUNT_ID")
TABLESPACE "TS_ACCT_ITEM_IDX";
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9417382/viewspace-932241/ ，如需转载，请注明出处，否则将追究法律责任。
