### 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/SourceGenerator.java
AggregationBuilder aggBuilder = container.aggs().asAggBuilder();
        if (aggBuilder != null) {
            source.aggregation(aggBuilder);
        }
        sorting(container, source);
        
        if (size != null) {
            int sz = container.limit() > 0 ? Math.min(container.limit(), size) : size;
            
            
            int minSize = container.minPageSize();
            sz = minSize > 0 ? (Math.max(sz / minSize, 1) * minSize) : sz;
            if (source.size() == -1) {
                source.size(sz);
            }
            if (aggBuilder instanceof CompositeAggregationBuilder) {
                
                if (container.sortingColumns().isEmpty()) {
                    ((CompositeAggregationBuilder) aggBuilder).size(sz);
                } else {
                    ((CompositeAggregationBuilder) aggBuilder).size(size);
                }
            }
        }
        optimize(container, source);
        return source;
    }
    private static void sorting(QueryContainer container, SearchSourceBuilder source) {
        if (source.aggregations() != null && source.aggregations().count() > 0) {