I am familiar with the core data tables for products and categories, i.e.
I know also that there are some tables that flatten indexes and this happens when you index products or categories. Question #1: Do they all end in _idx? Can someone help me identify them?
Reason: my company has a very large database of products and export is taking a while. I am considering exporting from production with all the index tables blank, and building them on the receiving end in QA.
Question #2: Will this work? Question #3: Will this provide a significant space/time savings?