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);