Share
ReportHello
Why is sql return a missing index when it exits?
InventTransIdx is a system index.
You’re offline. This is a read only version of the page.
1,867
Hello
Why is sql return a missing index when it exits?
InventTransIdx is a system index.
I assume you're talking about the advisor suggesting a new index to improve performance of a particular query.
The difference is that the standard index includes Partition and DataAreaId fields, while the suggested index doesn't.
I don't know your query, but maybe it was a cross-company query, or the advisor decided that having an index with InventTransId only (which has much better selectivity than Partition and DataAreaId) is worth the effort. It also depends on what statistics are available to the advisor.
In either case, you shouldn't simply create all indexes suggested by the advisor. It's a mere suggestion and the decision is up to you. A common example is when the query is rare and the cost of maintaining the index would outweigh the benefits.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,942
Super User 2024 Season 2
#2
Martin Dráb
229,389
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (