Selective Indexing: Do I need to make sure queries only use the indexed elements?
Hi, especially with the FTINDEX, say I indexed all <Foo> elements with a fulltext query that asks for any elments, e.g. //*[text() contains text { 'bar', 'baz' } any] would this only use the <Foo> elements or traverse all other elments (without index) as well? How about ft:search("DB", "bar") - would this behave differently? Regards, Max
Hi Max,
especially with the FTINDEX, say I indexed all <Foo> elements with a fulltext query that asks for any elments, e.g.
//*[text() contains text { 'bar', 'baz' } any]
Queries of this type will be evaluated by sequential scans, because all nodes need to be accessed anyway. You can check the query info to see if the index will be utilized.
How about ft:search("DB", "bar") - would this behave differently?
This one will only give you results from the index (The documentation says: »Returns all text nodes from the full-text index of the database $db that contain the specified $terms.«). Hope this helps Christian
participants (2)
-
Christian Grün -
Maximilian Gärber