Hi,
The most common use of an index on @ID is where the ids are a sparse set of
values and you want to find those in a specific range. For example, if I
have a file where the id is the date but not all dates are present, I might
want to do
LIST MYFILE WITH DATE >= "1 Jan 08" AND <= "31 Dec 08"
With an index on @ID, this only reads the records that exist. With no index,
it must read the entire file.
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
