Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email firstname.lastname@example.org.
I’ve created a custom index on one of the columns in catalog_product_flat_1. I need that for some custom reports I have to run. But periodically when I try to run my report query I find the index is missing. The table must get recreated periodically. Where/how can I add the code module-wise to create my index properly instead of just adding it on the DB when I need to create the report?