One weird index name in execution plan
Hi All,
Today someone came to me to aks my help on tuning one SQL. The follow is excerp of the whole plan. Although I resovled the performance issue, I still can't understand why
the index with name 'BIN$ld5VAtb88PngQAB/AQF8hg==$0' as the like appear in the plan.
If I remember correctly, this kind of names mean the objects are in the recycle bin. But can the index that has been dropped be used in execution plan?
Could someone see any potential problem implied by this kind of index name, just index name, please?
Best regards,
Today someone came to me to aks my help on tuning one SQL. The follow is excerp of the whole plan. Although I resovled the performance issue, I still can't understand why
the index with name 'BIN$ld5VAtb88PngQAB/AQF8hg==$0' as the like appear in the plan.
If I remember correctly, this kind of names mean the objects are in the recycle bin. But can the index that has been dropped be used in execution plan?
Could someone see any potential problem implied by this kind of index name, just index name, please?
Best regards,
0