Cases Where Positive Performance Effects Are Most Likely To Occur
The greatest improvement in the performance of querying column‑partitioned tables occurs when a request specifies a highly selective predicate on a column in a single‑column partition of a column‑partitioned table with hundreds or thousands of columns and only a small number of them are projected by the request.