2019-03-27から1日間の記事一覧

プランナ統計情報確認

DB

Oracle select * from all_tab_statistics where OWNER = 'TEST' and TABLE_NAME = 'TAB1';select * from all_ind_statistics where OWNER = 'TEST' and TABLE_NAME = 'TAB1'; select * from all_TAB_COL_STATISTICS where OWNER = 'TEST' and TABLE_NAME = …