A couple of weeks ago, I published a blog post that said specifying a partition name in the FROM clause of a query would prevent an existing cursor from being hard parsed when a partition is dropped from the same table. This was not correct. It’s actually impossible for us not to re-parse the existing … Continue reading Avoiding reparsing SQL queries due to partition level DDLs – Part 1