4 ms·
On azure, SQL database advisor suggest (and automatically apply if you want) indexes based on the workload of the db. If you decide to apply the index, it evalu
by davidelettieri 4y ago
On azure, SQL database advisor suggest (and automatically apply if you want) indexes based on the workload of the db. If you decide to apply the index, it evaluates for a while if it is working as expected and if not it rollbacks the index creation
https://azure.microsoft.com/it-it/blog/simplify-performance-tuning-and-troubleshooting-with-azure-sql-database/ https://azure.microsoft.com/it-it/blog/simplify-performance-...
- vyrotek 4y agoThis is a great feature. We manually added the indexes it recommended for a while but eventually found ourselves always adding the suggestions so we turned on the automatic creation.
- RajT88 4y agoAzure Cosmos also has a default index which you can override for better performance.
- chasil 4y agoI have only used it on Oracle 10g, but dbms_sqltune is a PL/SQL package that implements the SQL Tuning Advisor. I wrote some PHP for my users to find their queries and run the analyzer, and it will suggest new indexes among other performance-enhancing options. There is also this SQLite index suggestion tool on the front page today... https://news.ycombinator.com/item?id=31991598 https://news.ycombinator.com/item?id=31991598
- bingaling 4y agoSome analysis of the Azure / Sql Server 2017+ automatic index tuning: https://www.brentozar.com/archive/2019/02/what-does-azure-sql-db-automatic-index-tuning-actually-do-and-when/ https://www.brentozar.com/archive/2019/02/what-does-azure-sq...