Learning is not a spectator sport

In the previous post we saw that even though we had done an exchange partition mid-flights through a query execution, the query kept on running to successful completion. The database managed to find the data from the exchanged partition and keep on executing. The logical next question is – is that always the case? What…