### 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
try {
                    listener.onResponse(searchResponse);
                } catch (Exception e) {
                    closePointInTimeAfterError(client, pitId, e, listener);
                }
            }, searchError -> closePointInTimeAfterError(client, pitId, searchError, listener));
            client.search(search, closePitOnErrorListener);
        }, listener::onFailure));
    }
    private static void closePointInTimeAfterError(Client client, String pointInTimeId, Exception e, ActionListener<?> listener) {
        closePointInTime(client, pointInTimeId, wrap(r -> listener.onFailure(e), closeError -> {
            e.addSuppressed(closeError);
            listener.onFailure(e);
        }));
    }
    public static void closePointInTime(Client client, String pointInTimeId, ActionListener<Boolean> listener) {
        if (pointInTimeId != null) {
            
            client = client instanceof ParentTaskAssigningClient wrapperClient ? wrapperClient.unwrap() : client;
            client.execute(
                ClosePointInTimeAction.INSTANCE,
                new ClosePointInTimeRequest(pointInTimeId),
                wrap(clearPointInTimeResponse -> listener.onResponse(clearPointInTimeResponse.isSucceeded()), listener::onFailure)
            );
        } else {
            listener.onResponse(true);
        }
    }
    public static SearchRequest prepareRequest(SearchSourceBuilder source, SqlConfiguration cfg, boolean includeFrozen, String... indices) {
        source.timeout(cfg.requestTimeout());