9 Jul
2010
9 Jul
'10
2:28 p.m.
I wonder if the full-text index is also available to attribute nodes:
Unfortunately it's not; as most queries we know are based on text nodes, we decided to skip attribute full-text requests. Note, however, that special characters, such as "[", are ignored anyway.
The full-test was activated using the console:
create index fulltext Index created in 562.23 ms. OPTIMIZE Database optimized in 27349.05 ms. SET FTINDEX Full-Text Index: ON
Just as a hint (the documentation is very sparse on that): optimize is only needed after database updates. If FTINDEX is set to ON, all subsequent database creations will include fulltext indexing. Christian