Sphinx question. Is it possible to implement a faceted search on such a structure?

Question

Sphinx

I know that based on Sphinx you can do faceted search. Can it be done only with some predefined database structures? Well, for example, with EAV, MVA, etc.?
I'm currently looking at a script for the Real Estate Agency (someone's self-written). There is such a structure.
Table "object_base" | contains the main fields that ALL objects of
the Table have - object types "home", "apartments", ... | inherited (supplemented) from tables object_base; contain individual fields of the corresponding object types
Tables "home_rent" "apartments_sale" | are inherited (complemented) from their corresponding rent_home tables from home. And contain only those fields that are in the Sale / Rent
Table "values" | sets of unique values ​​(eg "property Repair" : design, cosmetic, EURO), all values ​​in one table with their IDs.
Accordingly, the question is: is it possible to fasten Sphinx to such a structure and set up a faceted search?
UPD: By the way, the same question, only for ElasticSearch

Answer 1

and the point is to twist the sphinx here, for ten thousand records it will fly on a muscle.