When retrieving data from a table which type of query will benefit the MOST from...

Queries with unpredictable data volumes.

Queries with highly-selective table filters that return a small subset of rows.

Queries on fields in a VARIANT column that will return all data as structured data.

Queries that involve one or more columns inside the cluster key using the lowest cardinality to select filters.