Why does optimizer access empty partitions also when filtered for a date range?

UDA

Why does optimizer access empty partitions also when filtered for a date range?

Why does optimizer access empty partitions also when filtered for a date range? Any idea?
2 REPLIES
Senior Apprentice

Re: Why does optimizer access empty partitions also when filtered for a date range?

Because only *you* know that a partition is empty, but the optimizer doesn't.
Even if statistics exist, they might be wrong.

Dieter

Re: Why does optimizer access empty partitions also when filtered for a date range?

test to reply