You have an Azure SQL database that contains multiple database tables in it. You are asked to improve the performance of the database with a reduced or minimized administrative effort.
Use the “automatic tuning” option in SQL Azure.
Azure SQL Database automatic tuning option provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning. Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their performance.
Know more about automatic tuning in Azure SQL in the automatic tuning docs.