the correct balance will differ according to the specifics of the workload, but in general it’s a good idea to deal with your most often-operate queries with indexes, but not go overboard and check out making sure https://www.ralantech.com/database-performance-tuning-and-optimization-company/