How magento creates flat tables and what are the entities that are converted to flat table?
Can you list all the flat tables created by magento?
What are the events which lead to indexing required?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
mostly the following tables can be truncted,
core_cache core_cache_option core_cache_tag log_customer log_quote log_summary log_summary_type log_url log_url_info log_visitor log_visitor_info log_visitor_online enterprise_logging_event enterprise_logging_event_changes index_event index_process_event report_event report_viewed_product_index dataflow_batch_export dataflow_batch_import