インデックス作成

Sample : インデックス作成

リポジトリを動作をよくするためにインデックスを作成します。
これによりリポジトリの IO 速度が短くなります。画面数が少ないリポジトリではさほど効果はありませんが、画面数が多いリポジトリでは効果が期待できます。

1.インデックス作成SQL
2.インデックス除去SQL

インデックス作成SQL↑top

データベースによっては対応していない場合もありますので、ご注意下さい。

CREATE INDEX W_IDX_CS_CALL_STRAN ON  WEDGE_CS_CALL_STRAN (serversub_id);
CREATE INDEX W_IDX_CS_CALL_STRAN_IN_RECORD ON  WEDGE_CS_CALL_STRAN_IN_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_CALL_STRAN_OUT_RECORD ON  WEDGE_CS_CALL_STRAN_OUT_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_DECISION_DLCP ON  WEDGE_CS_DECISION_DLCP (serversub_id);
CREATE INDEX W_IDX_CS_DECISION_TABLE ON  WEDGE_CS_DECISION_TABLE (serversub_id);
CREATE INDEX W_IDX_CS_DECISION_TYPE ON  WEDGE_CS_DECISION_TYPE (serversub_id);
CREATE INDEX W_IDX_CS_DLCP ON  WEDGE_CS_DLCP (serversub_id);
CREATE INDEX W_IDX_CS_DLCP_IN_RECORD ON  WEDGE_CS_DLCP_IN_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_DLCP_OUT_RECORD ON  WEDGE_CS_DLCP_OUT_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_SERVERDATA ON  WEDGE_CS_SERVERDATA (serversub_id);
CREATE INDEX W_IDX_CS_SRULE ON  WEDGE_CS_SRULE (serversub_id);
CREATE INDEX W_IDX_CS_SRULE_IN_RECORD ON  WEDGE_CS_SRULE_IN_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_SRULE_OUT_RECORD ON  WEDGE_CS_SRULE_OUT_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_STRAN ON  WEDGE_CS_STRAN (serversub_id);
CREATE INDEX W_IDX_CS_STRAN_IN_RECORD ON  WEDGE_CS_STRAN_IN_RECORD (serversub_id);
CREATE INDEX W_IDX_CS_STRAN_OUT_RECORD ON  WEDGE_CS_STRAN_OUT_RECORD (serversub_id);

CREATE INDEX W_IDX_CS_COMPONENT ON  WEDGE_CS_COMPONENT(frame_id);
CREATE INDEX W_IDX_CS_CRULE ON  WEDGE_CS_CRULE(frame_id);
CREATE INDEX W_IDX_CS_CRULE_IN_RECORD ON  WEDGE_CS_CRULE_IN_RECORD(frame_id);
CREATE INDEX W_IDX_CS_CRULE_OUT_RECORD ON  WEDGE_CS_CRULE_OUT_RECORD(frame_id);
CREATE INDEX W_IDX_CS_CTRAN ON  WEDGE_CS_CTRAN(frame_id);
CREATE INDEX W_IDX_CS_CTRAN_IN_RECORD ON  WEDGE_CS_CTRAN_IN_RECORD(frame_id);
CREATE INDEX W_IDX_CS_CTRAN_OUT_RECORD ON  WEDGE_CS_CTRAN_OUT_RECORD(frame_id);
CREATE INDEX W_IDX_CS_EXECUTE_TIMING ON  WEDGE_CS_EXECUTE_TIMING(frame_id);
CREATE INDEX W_IDX_CS_EXECUTION_D ON  WEDGE_CS_EXECUTION_D(frame_id);
CREATE INDEX W_IDX_CS_EXECUTION_H ON  WEDGE_CS_EXECUTION_H(frame_id);
CREATE INDEX W_IDX_CS_FRAME_IN_RECORD ON  WEDGE_CS_FRAME_IN_RECORD(frame_id);
CREATE INDEX W_IDX_CS_FRAME_OUT_RECORD ON  WEDGE_CS_FRAME_OUT_RECORD(frame_id);
CREATE INDEX W_IDX_CS_GROUP_D ON  WEDGE_CS_GROUP_D(frame_id);
CREATE INDEX W_IDX_CS_GROUP_H ON  WEDGE_CS_GROUP_H(frame_id);
CREATE INDEX W_IDX_CS_ITEM ON  WEDGE_CS_ITEM(frame_id);
CREATE INDEX W_IDX_CS_LAYOUT ON  WEDGE_CS_LAYOUT(frame_id);
CREATE INDEX W_IDX_CS_ORDER ON  WEDGE_CS_ORDER(frame_id);
CREATE INDEX W_IDX_CS_PROPERTY ON  WEDGE_CS_PROPERTY(frame_id);
CREATE INDEX W_IDX_CS_TABLE_D ON  WEDGE_CS_TABLE_D(frame_id);
CREATE INDEX W_IDX_CS_TABLE_H ON  WEDGE_CS_TABLE_H(frame_id);

インデックス除去SQL↑top

前章で設定したインデックスを取り除くためのSQLです。

DROP INDEX W_IDX_CS_CALL_STRAN;
DROP INDEX W_IDX_CS_CALL_STRAN_IN_RECORD;
DROP INDEX W_IDX_CS_CALL_STRAN_OUT_RECORD;
DROP INDEX W_IDX_CS_DECISION_DLCP;
DROP INDEX W_IDX_CS_DECISION_TABLE;
DROP INDEX W_IDX_CS_DECISION_TYPE;
DROP INDEX W_IDX_CS_DLCP;
DROP INDEX W_IDX_CS_DLCP_IN_RECORD;
DROP INDEX W_IDX_CS_DLCP_OUT_RECORD;
DROP INDEX W_IDX_CS_SERVERDATA;
DROP INDEX W_IDX_CS_SRULE;
DROP INDEX W_IDX_CS_SRULE_IN_RECORD;
DROP INDEX W_IDX_CS_SRULE_OUT_RECORD;
DROP INDEX W_IDX_CS_STRAN;
DROP INDEX W_IDX_CS_STRAN_IN_RECORD;
DROP INDEX W_IDX_CS_STRAN_OUT_RECORD;

DROP INDEX W_IDX_CS_COMPONENT;
DROP INDEX W_IDX_CS_CRULE;
DROP INDEX W_IDX_CS_CRULE_IN_RECORD;
DROP INDEX W_IDX_CS_CRULE_OUT_RECORD;
DROP INDEX W_IDX_CS_CTRAN;
DROP INDEX W_IDX_CS_CTRAN_IN_RECORD;
DROP INDEX W_IDX_CS_CTRAN_OUT_RECORD;
DROP INDEX W_IDX_CS_EXECUTE_TIMING;
DROP INDEX W_IDX_CS_EXECUTION_D;
DROP INDEX W_IDX_CS_EXECUTION_H;
DROP INDEX W_IDX_CS_FRAME_IN_RECORD;
DROP INDEX W_IDX_CS_FRAME_OUT_RECORD;
DROP INDEX W_IDX_CS_GROUP_D;
DROP INDEX W_IDX_CS_GROUP_H;
DROP INDEX W_IDX_CS_ITEM;
DROP INDEX W_IDX_CS_LAYOUT;
DROP INDEX W_IDX_CS_ORDER;
DROP INDEX W_IDX_CS_PROPERTY;
DROP INDEX W_IDX_CS_TABLE_D;
DROP INDEX W_IDX_CS_TABLE_H;

Developer'sWorks

Sample : インデックス作成

インデックス作成SQL↑top

インデックス除去SQL↑top