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 community@magento.com.

Magento Forum

custom index on catalog_product_flat_1 disappears
 
shanana
Jr. Member
 
Total Posts:  11
Joined:  2009-04-26
 

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?

Thanks in advance for your ideas.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top