create or replace table accountstat ( accountId int not null, statId int not null, value bigint null, primary key (accountId, statId) ) charset=latin1; create or replace index statId on accountstat (statId);