Page 2 of 2

Indexing differences between Vortex and TSQL

Posted: Thu Dec 13, 2012 1:10 pm
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.