create index IDX_FRM_01 ON T_A_FORUM(I_TOPIC_COUNT);

create index IDX_FRM_02 ON T_A_FORUM(I_POST_COUNT);
create index IDX_FRM_03 ON T_A_FORUM(I_HIT_COUNT);
create index IDX_FRM_04 ON T_A_FORUM(I_TOPIC_COUNT);
create index IDX_FRM_05 ON T_A_FORUM(I_PARENT_FORUM_ID, I_ORDER);
create index IDX_FRM_06 ON T_A_FORUM(I_PARENT_FORUM_ID, T_NAME);


create index IDX_LAST_LOGIN INDEX ON T_A_USER(B_LOGGED, R_LAST_LOGIN);


create index IDX_BIT_01 ON T_P_GROUP_FORUM_ACCESS(B_R);
create index IDX_BIT_02 ON T_P_GROUP_FORUM_ACCESS(B_W);
create index IDX_BIT_03 ON T_P_GROUP_FORUM_ACCESS(B_RW);
create index IDX_BIT_13 ON T_P_GROUP_SECTION(B_R);
create index IDX_BIT_14 ON T_P_GROUP_SECTION(B_W);
create index IDX_BIT_15 ON T_P_GROUP_SECTION(B_RW);
create index IDX_BIT_16 ON T_P_GROUP_SECTION(B_D);
create index IDX_BIT_04 ON T_P_USER_FORUM_ACCESS(B_R);
create index IDX_BIT_05 ON T_P_USER_FORUM_ACCESS(B_W);
create index IDX_BIT_06 ON T_P_USER_FORUM_ACCESS(B_RW);
create index IDX_BIT_07 ON T_P_USER_FORUM_ACCESS(B_MOD);
create index IDX_BIT_17 ON T_P_USER_SECTION(B_R);
create index IDX_BIT_18 ON T_P_USER_SECTION(B_W);
create index IDX_BIT_19 ON T_P_USER_SECTION(B_RW);
create index IDX_BIT_20 ON T_P_USER_SECTION(B_D);
create index IDX_BIT_08 ON T_P_USER_TOPIC_ACCESS(B_R);
create index IDX_BIT_09 ON T_P_USER_TOPIC_ACCESS(B_RW);
create index IDX_BIT_10 ON T_P_USER_TOPIC_ACCESS(B_MOD);

create index IDX_BIT_11 ON T_S_TOPIC(B_R);
create index IDX_BIT_12 ON T_S_TOPIC(B_RW);


create index IDX_POST_01 ON T_S_POST(B_MOD_ATT);
create index IDX_POST_ORDER ON T_S_POST(I_TOPIC_ID, R_INSERT);

create index IDX_POST_02 ON T_S_POST(I_USER_ID, S_IP);


create index IDX_TPC_01 ON T_S_TOPIC(I_FORUM_ID, R_INSERT);
create index IDX_TPC_02 ON T_S_TOPIC(I_POST_COUNT);
create index IDX_TPC_03 ON T_S_TOPIC(I_HIT_COUNT);


create index IDX_HIT_1 ON T_S_TOPIC_HIT(I_USER_ID, R_HIT);


create index IDX_USER_FEED ON T_S_USER_FEED(I_USER_ID, I_ORDER);
create index IDX_USER_FBMK ON T_S_USER_FORUM_BMK(I_USER_ID, I_ORDER);


create index IDX_USER_01 ON T_A_USER(i_post_count);

create index idx_banned_ip on t_a_banned_ip(s_ip);

create index idx_login_ip on t_s_user_login(i_user_id, s_ip);

create index idx_user_new on t_p_user_topic(i_user_id, b_new);

create index idx_user_bmk on t_p_user_topic(i_user_id, b_bookmark);

create index idx_user_notify on t_p_user_topic(i_user_id, b_notify);


create index idx_file_mt on t_a_file(t_mime_type);

create index idx_emo_order on t_r_emoticon(i_order);
create index idx_mtype on t_e_mime_type(t_mime_type);