I am working on creating the page_views_2010 archive database and have a follow up question:
Is it wise to create the archive table using CREATE table AS SELECT... syntax?
I notice the table doesn't end up having a column marked as the primary key or the autoincrement feature.
Should I create the table from the page_views table structure dump and then populate it separately?
Thanks for any input.