Optimizing a table for analytics and maintenance proved trickier than I expected.

For SQL Server metadata, the information schema views may not be suitable for all of your needs. Here is an example involving table constraints.