Practica guiada | COF-C03 Study Lab

Pregunta 1 de 10 MEDIUM · single

Leer en espanol

Which measure usually addresses first a query that scans many micro-partitions due to poorly selective filters?

Increase warehouse size so Cloud Services discards more micro-partitions before execution. Review filters and pruning Immediately define a clustering key on the filtered columns before measuring pruning, depth, and real pattern frequency. Keep the warehouse warm so local cache is reused for those poorly selective scans.

Marcar para repasar

Practica guiada con una sola pregunta visible y correccion explicada.

Which measure usually addresses first a query that scans many micro-partitions due to poorly selective filters?