# Sphinx-FTS index structure details?
**URL:** https://forums.percona.com/t/sphinx-fts-index-structure-details/2086
**Category:** Sphinx & Full-Text Search
**Created:** [May 16, 2010, 11:11pm UTC](https://forums.percona.com/t/sphinx-fts-index-structure-details/2086 "2010-05-16T23:11:34Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@nageshvh](https://forums.percona.com/u/nageshvh)
#### Post date: [May 16, 2010, 11:11pm UTC](https://forums.percona.com/t/sphinx-fts-index-structure-details/2086/1 "2010-05-16T23:11:34Z")
Hi,
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.
---
### Author:  [@xaprb](https://forums.percona.com/u/xaprb)
#### Post date: [May 17, 2010, 7:53am UTC](https://forums.percona.com/t/sphinx-fts-index-structure-details/2086/2 "2010-05-17T07:53:33Z")
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.
---
### Author:  [@nageshvh](https://forums.percona.com/u/nageshvh)
#### Post date: [May 18, 2010, 2:49pm UTC](https://forums.percona.com/t/sphinx-fts-index-structure-details/2086/3 "2010-05-18T14:49:04Z")
Thank you. I found the info I was looking in their source code docs and forums )