Update:
Root cause has been found and it has nothing to do with version of the Hibernate but with parameters handling. By default all literals are sent to DB as parameters, thus preventing database to create optimal query plan. On the other hand this approach should save time for query compilation. If the query compilation time is not an issue you can inline all literals using setting in persistence.xml
<property name="hibernate.criteria.literal_handling_mode" value="inline"/>
Some materials I´ve found along the way to study:
https://use-the-index-luke.com/sql/where-clause/bind-parameters
https://bertwagner.com/2017/08/08/why-parameter-sniffing-isnt-always-a-bad-thing-but-usually-is/