gistfile1.txt

-- Empty tweet table
TRUNCATE TABLE  `tweets_feeds`;

-- Empty tweet archive table
TRUNCATE TABLE  `tweets_archive`;

-- Empty feeds archive table
TRUNCATE TABLE `predef_archives`

-- Delete all feeds which are archived
DELETE FROM `predef_feeds` WHERE `Archive` = 1;

-- Add index to the ReplyID column
ALTER TABLE  `tweets_feeds` ADD INDEX (`ReplyID`);

-- Add index to the Active column
ALTER TABLE  `predef_feeds` ADD INDEX (`Active`);