Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Sphinx-FTS index structure details?

nageshvhnageshvh EntrantCurrent User Role Beginner
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

1) How does sphinx support FTS on multiple attributes of a single table?
2) How does it support for FTS on multiple attributes of multiple tables?
3) 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.


  • xaprbxaprb Mentor Inactive User Role Beginner
    Sphinx doesn't search tables. It searches an index, which you build from a query. You can write that query anyway you want, including JOINs.

    It sounds like you might need to read through the Sphinx manual again. If you've already read it, give it another try; sometimes things make more sense the second time. Sphinx is a complex tool with lots to understand.
  • nageshvhnageshvh Entrant Current User Role Beginner
    Thank you. I found the info I was looking in their source code docs and forums )
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.