magemail-indexes.sql

ALTER TABLE `sales_flat_order_item` ADD INDEX `IDX_SALES_FLAT_ORDER_ITEM_PRODUCT_ID` (`product_id`);
ALTER TABLE `cataloginventory_stock_status` ADD INDEX `IDX_CATALOGINVENTORY_STOCK_STATUS_STOCK_STATUS` (`stock_status`);
ALTER TABLE `cataloginventory_stock_status` ADD INDEX `IDX_CATALOGINVENTORY_STOCK_STATUS_PRODUCT_ID` (`product_id`);
ALTER TABLE `sales_flat_order` ADD INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_EMAIL` (`customer_email`);
ALTER TABLE `sales_flat_order` ADD INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`);
ALTER TABLE `sales_flat_quote` ADD INDEX `IDX_SALES_FLAT_QUOTE_CUSTOMER_EMAIL` (`customer_email`);
ALTER TABLE `sales_flat_quote` ADD INDEX `IDX_SALES_FLAT_QUOTE_UPDATED_AT` (`updated_at`);
ALTER TABLE `sales_flat_quote_item` ADD INDEX `IDX_SALES_FLAT_QUOTE_ITEM_CREATED_AT` (`created_at`);
ALTER TABLE `sales_flat_quote_item` ADD INDEX `IDX_SALES_FLAT_QUOTE_ITEM_UPDATED_AT` (`updated_at`);
ALTER TABLE `catalog_product_entity` ADD INDEX `IDX_CATALOG_PRODUCT_ENTITY_UPDATED_AT` (`updated_at`);