SQL Server: index manquant vs index inutilisé, comment décider ?
asked 2 months ago184 viewsfr
Le plan d'exécution suggère un index manquant, mais j'ai déjà beaucoup d'index. Comment savoir lesquels sont réellement utilisés et lesquels ralentissent les écritures ?
AI diagnosis
AI-generated. Not an answer — the community below confirms or corrects it. Always verify before relying on it.
2 Answers
Set output: 'standalone' in next.config, deploy the .next/standalone folder, and set the App Service startup command to node server.js. Use WEBSITE_NODE_DEFAULT_VERSION = ~20 and configure env vars under Configuration → Application settings.
Sign in to tell others whether this worked.
Query sys.dm_db_index_usage_stats for reads vs writes since last restart. Indexes with high user_updates and zero user_seeks/scans are candidates for removal. Add the missing index only if the query is frequent and selective.
Sign in to tell others whether this worked.
Sign in and verify your email to post an answer.