You can use the Azure Portal for performance recommendations which can help you optimize the performance of your DB.
Check this link : https://learn.microsoft.com/en-us/azure/azure-sql/database/database-advisor-find-recommendations-portal?view=azuresql