【Oracle】インデックス構築の目安
// ANLAYZE生成SQL
select 'anlayze index ' || index_name || ' VALIDATE STRUCTURE;' from user_indexes where index_name like 'IX%';
// 再構築の目安
// HEIGHT => 4
// DEL_LF_ROW/LF_ROWS > 0.2
select NAME,HEIGHT,DEL_LF_ROWS/LF_ROWS as ROW_WARIAI from index_stats;
// 再構築
ALTER INDEX IX_TRN091DF_00 REBUILD;
select 'anlayze index ' || index_name || ' VALIDATE STRUCTURE;' from user_indexes where index_name like 'IX%';
// 再構築の目安
// HEIGHT => 4
// DEL_LF_ROW/LF_ROWS > 0.2
select NAME,HEIGHT,DEL_LF_ROWS/LF_ROWS as ROW_WARIAI from index_stats;
// 再構築
ALTER INDEX IX_TRN091DF_00 REBUILD;