Hello
I've got standart HQL query. Suppose this query returns 1% of all rows. Then I need to make fulltext search (Hibernate Search) on the result of HQL. How can I make it?

Hi,
I'm sorry that's not supported , as there is no way to solve such a requirement efficiently by Hibernate Search; there are however ways around it, but require some tricks from your part.

what you would need to do is load the entities you need via HQL and intersect the resultset with what you find via a FullText query.

Usually you should try to put in the index some additional metadata so that you can solve the query only via the index and avoid this limitation altogether.

Thank you

Do you have any statistic which solution is preferred to use in which cases?

My collection to be limited is less then 0.1% of all rows, HQL has about 3-5 restriction conditions

you should try index the fields you need to apply those restrictions