create or replace table accountkits ( accountId int not null, kitId int null, active tinyint(1) not null ); create or replace index accountKitStats on accountkits (kitId, accountId);