A query is taking different explain plans. how is that possible?
The same query when executed for the first time it takes one explain plan and for the second time a different explain plan. It keeps changing.
please tell me that how is this possible?
Looking for experts views here, thanks in advance.