Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Index not work
- Thread starter nasrin
- Start date
Hi Nasrin,
After you mlade your index using
INDEX ON theField TO theField.idx
did you also run a
SET INDEX TO theField.idx
afterwards?
Otherwise, there is no 'live' link between the data and the index file.
If that doesn't help, it could be that the active index file is overridden by another.
Check if there is another SET INDEX TO later on, that is not ADDITIVE.
Also check for switches between indexes by
SET ORDER TO <expN>
Just a few thoughts,
Jan Schenkel.
" As we grow older, we grow both wiser and more foolish at the same time." (De Rochefoucald)
After you mlade your index using
INDEX ON theField TO theField.idx
did you also run a
SET INDEX TO theField.idx
afterwards?
Otherwise, there is no 'live' link between the data and the index file.
If that doesn't help, it could be that the active index file is overridden by another.
Check if there is another SET INDEX TO later on, that is not ADDITIVE.
Also check for switches between indexes by
SET ORDER TO <expN>
Just a few thoughts,
Jan Schenkel.
" As we grow older, we grow both wiser and more foolish at the same time." (De Rochefoucald)
- Status
