Newly created index not appearing Here's a weird thing: In SQL Server 2017 Standard, I created a new index on one of my tables which already had a few indexes on it, by running the following in SSMS:
create unique index UQ_GtsCbotCurve_InvCatProTypMdOd
ON GtsCbotCurve (InventoryId, CategoryId, ProviderId, TypeId, MarkDate, ObservationDate)

SSMS said &quot;Query executed successfully&quot;.
I hit F5 to refresh SSMS's view of the table, but the new index did not appear in the Indexes node under that table in the object explorer.
I listed the indexes on the table using the system catalog tables like this:
select *
from sys.indexes ix
     inner join sys.objects ob on ix.object_id = ob.object_id
where ob.name = 'GtsCbotCurve'

and the new index did not appear there.
But when I rerun the create index statement, it errors out, saying &quot;an index or statistics with that name already exists on GtsCbotCurve&quot;.
I disconnected from the server, and reconnected, but the index still doesn't appear.
What could be going on here? Does the index actually exist? How do I get it to appear in the management tools?
Is it possible you had just an empty space highlighted in SSMS when you ran the query? If so, it'll still say &quot;query executed successfully&quot; even though nothing actually executed. If you're able to create the index now, then it definitely didn't create the first time.