MD Partition Prequery Option

The purpose of the MD Partition Prequery Option is to find out which partition base table is used. The report filter is combined with partition base table filters. If the intersection of both filters is not empty, then the corresponding partition base table should be used. A SELECT statement for each partition base table is generated, and the query result is checked to see whether it is empty.

There are multiple ways to generate a SELECT statement that checks for the data, but the performance of the query can differ depending on the platform. The default value for this property is: "select count(*) …" for all database platforms, except UDB, which uses "select distinct 1…"

Levels at Which You Can Set This

Database instance, report, and template