September 17, 2019 at 7:07 pm
What are the different ways you can check if very long query is dropping index. I did find and search something like below however did not find any however I suspect it is dropping and would like to learn and confirm.
DROP INDEX [IF EXISTS] index_name
ON table_name;
However was curious to know if I am missing on checking somewhere else if script may drop one or two idx.
Share your thoughts!
Thanks,
September 17, 2019 at 8:58 pm
The default trace and the Schema Change report would show index drops, creations. The report captures what is in the traces so the two are basically the same. Those would be limited by time in that if your trace files have rolled off since the index change, you wouldn't have the information.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply