DB

Index 재빌드 및 분석

Lawmin 2010. 4. 8. 09:51
ALTER INDEX dset_ent_pk REBUILD;

ANALYZE INDEX dset_ent_pk VALIDATE STRUCTURE;

SELECT blocks, btree_space, used_space, pct_used "사용율(%)", lf_rows,
       del_lf_rows "삭제행"
  FROM index_stats;