Thanks a lot for the clear explanation Maria ! I will check in my developpers code to find out this kind of mistake. Because, right now, I am adding my partition and subpartition name in the query to force prunning !🤓
Adding the partition name to the FROM clause will always result in pruning, but it requires detailed knowledge of both the schema and the data. For most, that is a luxury we don't have. Good luck with the code review! 😀
Maria, apart from internal data type conversion is there any other possible reason where partition pruning not used. I have issue where data type of partition column and filter is as date and query still doing table full scan(all partition scan)