Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2023 02:19 AM
No hints on partition pruning afaik.
The reason the partitions were not pruned is because the second query generates a completely different plan.
To be able to filter the partitions, a join first has to happen. And in this case it means the table has to be scanned.