Indexing differences between Vortex and TSQL

User avatar
Kai
Site Admin
Posts: 1271
Joined: Tue Apr 25, 2000 1:27 pm

Indexing differences between Vortex and TSQL

Post by Kai »

If the PARAMS value for an index is blank/empty, it is a v5 index. Note also that during CREATE INDEX, if the index already existed beforehand (i.e. this is an update not a create), the current APICP/texis.ini/SQL-set index settings are ignored: only the ones set at CREATE INDEX *creation* are used. This is for consistency: all parts of the index must be built with the same textsearchmode, index expressions, noise etc. That probably explains why all the SYSINDEX.PARAMS values are empty: they were created under v5, and you haven't dropped them since: even if you've run CREATE INDEX with v6 settings since then, the new settings cannot take effect.

Did you try dumping the two _P.tbl files (tsql- and Vortex-created) via addtable/SELECT? Try that and diff the results; I'd like to see what is different.
Post Reply