Not necessarily so... An index on the primary key will not only allow you to sort or sselect the file by that key instantly, but also allow quick selects on partial keys (e.g. select myfile with key = 12345]). Admittedly esoteric, but on occasion handy.
Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Friday, March 11, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/