I have a table A which is having indexes as well, however the index is not being utilized and going for full table scan. Whereas when I created its backup table A_BK, the index is being utilized thus going for index scan. My query is why my original online table A is not utilizing the index?
Note: I have gathered table stats, index stats also I tried rebuilding the index online. however still my online table A not utilizing the index.