I have been working with software development for over thirteen years. I have extensive experience tuning queries and database performance. Some common techniques are: creating missing indices, data redundancy, materialized views, facts tables, data partitioning, and sharding.