Lines Matching refs:index

4   Normally, in order to create a full-text index on a dataset, the FTS4 
18   the full-text index, the content option can sometimes be used to achieve 
73   to the content table does not affect the full-text index. It is the
75   full-text index are consistent.
105     -- The query uses the full-text index to discover that the MATCH 
114     -- full-text index still indicates that the row with docid=3 matches
130   This is so that FTS4 can update the full-text index entries for each token
133   inconsistent with the contents of the FTS index, the results can be difficult
134   to predict. The FTS index may be left containing entries corresponding to the
139   Instead of writing separately to the full-text index and the content table,
140   some users may wish to use database triggers to keep the full-text index
160   values in order to update the full-text index. And the INSERT trigger must
167   deletes the entire full-text index and rebuilds it based on the current
174   only be useful if the full-text index has somehow become corrupt. It is an
175   error to attempt to rebuild the full-text index maintained by a contentless