Newly created index not appearing
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.