### Description

Tracking total hits sometimes has a non-negligible impact on performance. We should disable it when not strictly required.
x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/execution/search/Querier.java
super(listener, client, cfg, output, query, request);
            isPivot = query.fields().stream().anyMatch(t -> t.extraction() instanceof PivotColumnRef);
        }
        @Override
        protected void handleResponse(SearchResponse response, ActionListener<Page> listener) {
            CompositeAggregationBuilder aggregation = CompositeAggCursor.getCompositeBuilder(request.source());
            boolean mightProducePartialPages = CompositeAggCursor.couldProducePartialPages(aggregation);
            Supplier<CompositeAggRowSet> makeRowSet = isPivot
                ? () -> new PivotRowSet(
                    schema,
                    initBucketExtractors(response),
                    mask,
                    response,
                    aggregation.size(),
                    query.sortingColumns().isEmpty() ? query.limit() : -1,
                    null,
                    mightProducePartialPages
                )
                : () -> new SchemaCompositeAggRowSet(
                    schema,
                    initBucketExtractors(response),
                    mask,
                    response,
                    aggregation.size(),
                    query.sortingColumns().isEmpty() ? query.limit() : -1,
                    mightProducePartialPages
                );
            BiFunction<SearchSourceBuilder, CompositeAggRowSet, CompositeAggCursor> makeCursor = isPivot ? (q, r) -> {
                Map<String, Object> lastAfterKey = r instanceof PivotRowSet ? ((PivotRowSet) r).lastAfterKey() : null;
                return new PivotCursor(