Jeff Butera wrote:
I have a file with various indicies built on it:
File.................. COURSES
Alternate key length.. 20
Node/Block size....... 4K
OV blocks............. 1 (1 in use, 1 overflowed)
Indices............... 6 (6 D-type)
Index updates......... Enabled, No updates pending
Index-Name...... F-type K-type Built Empties Dups In-DICT S/M
F-no/VF-expr....
CRS.SUBJECT D Txt Yes No Yes Yes S 12
CRS.NO D Txt Yes No Yes Yes S 16
CRS.TERMS.OFFERED D Txt Yes No Yes Yes M 20
CRS.NAME D Txt Yes No Yes Yes S 4
I'm writing records to this file and correctly populating CRS.NAME.
Aftering doing so,
SELECT COURSES WITH CRS.NAME EQ 'foo'
fail for the newly add course 'foo' (regardless of the value of
CRS.NAME). However, if I reindex the file, the SELECT works. I'm all
ears if anyone can offer insight as to how/why the indicies aren't
getting updated until I force a reindex.
Can I assume that you truncated the display, so that the (6) indices
referred to actually exist rather than the (4) that you show?
Have you tried using the keywords REQUIRE.INDEX and NO.INDEX to compare
the results?
--
Allen Egerton
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
