Optimalisasi Database

July 29, 2010

# table purchase

• ALTER TABLE purchase ADD INDEX (`tanggal`);
• ALTER TABLE purchase ADD INDEX (`agenid`);
• ALTER TABLE purchase ADD INDEX (`vtype`);
• ALTER TABLE stockiest ADD INDEX (`tujuan`);
• ALTER TABLE stockiest ADD INDEX (`app_id`);
• ALTER TABLE stockiest ADD INDEX (`status`);

# table hpagen

ALTER TABLE hpagen ADD INDEX (`hp`);

ALTER TABLE hpagen ADD INDEX (`agenid`);

# table inbox_read

ALTER TABLE inbox_read ADD INDEX (`in_starttime`);

ALTER TABLE inbox_read ADD INDEX (`agenid);

# table outbox

ALTER TABLE outbox ADD INDEX (`out_starttime`);

ALTER TABLE outbox ADD INDEX (`agenid);

ALTER TABLE outbox ADD INDEX (`app_id`);

# table inbox_khusus

ALTER TABLE inbox_khusus ADD INDEX (`tanggal`);

ALTER TABLE inbox_khusus ADD INDEX (`app_id`);

ALTER TABLE inbox_khusus ADD INDEX (`sender`);

ALTER TABLE inbox_khusus ADD INDEX (`hp`);

# table mutasi

# table mutasi_bonus

# table voucher

# table statis

# table hpp_voucher

# table filter

# table prefix

# table deposit

• ALTER TABLE deposit ADD INDEX (`tanggal`);
• ALTER TABLE deposit ADD INDEX (`agenid`);