QuerySpatialCoverage

Provides insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning

For example, you can do the following with the QuerySpatialCoverage information:

• Add measure_name or use customer-defined partition key (CDPK) predicates.

• If you've already done the preceding action, remove functions around them or clauses, such as LIKE.