Queries leading to a performance recommendation

[dualdeva]

Hello, is there a way to display the main queries that led to a certaind “Create Index” performance recommendation? I have such a suggestion with the new composite index having two fields in switched places so there must be a heavily used query with a bad formed Where clause. Thank you

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: cb72afbe-53d9-3ca0-37b2-bdc00be47702
• Version Independent ID: d58f3b16-9a6b-0e8d-76eb-2021816a26b7
• Content: Apply performance recommendations - Azure SQL Database
• Content Source: azure-sql/database/database-advisor-find-recommendations-portal.md
• Service: sql-database
• Sub-service: performance
• GitHub Login: @NikaKinska
• Microsoft Alias: nnikolic

[Naveenommi-MSFT]

@dualdeva Thanks for your feedback! We will investigate and update as appropriate.

[shaktisingh-msft]

Hi @NikaKinska,

Could you please look into this, thanks.

[WilliamDAssafMSFT]

reassign:WilliamDAssafMSFT

[WilliamDAssafMSFT]

Hi @dualdeva, As with the missing index recommendations in SQL Server, the source queries (which may be numerous) that generated the index recommendation and the eventual CREATE INDEX statement are not visible.

please-close