I have been searching for quite a while about sphinx full text indexing structure and haven’t got specifically helpful results.
I intend to learn about sphinx indexing structure and answer these questions
- How does sphinx support FTS on multiple attributes of a single table?
- How does it support for FTS on multiple attributes of multiple tables?
- Does it allow the users to define materialized views to support search on multiple tables?
Any papers or links regarding this would be very helpful. Thanks a lot.