jbroder - 9:30 pm on Sep 13, 2011 (gmt 0)

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.

Jon