Optimizing of DB resources
Table count is not an indicator of optimization. It is actually opposite of what someone might think. Good database design breaks data up into multiple related tables that are kept small in field count. Drupal core has a very efficient relational database design compared to WordPress. I have experience with both platforms and your statement highlights what you must realize about Drupal. Drupal really is a content management framework, WordPress is a content management system. They are vastly different in their capabilities.

So to answer your question plainly, no optimization is required. It already is optimized for a relational database.

As always, choose the right tool for the project. Even though I am a Drupal developer I have recommended Wordpress to several clients. Because their needs and requirements could be satisfied with a simple Wordpress site.