Okay, cool :) I thought I was going crazy when I read that and that my knowledge of indexes was more bunk than it already is.
Thanks Tom!!! --JJ On Wed, Jan 28, 2009 at 1:52 PM, Tom Whitmore <tewhitm...@ratex.com> wrote: > No, you don't want to index on the ID because it is unique. That would be a > very inefficient index. If you created an i-descriptor that broke the ID > into several multi-valued parts, then it MAY help, but I don't think it is > worth the overhead. > > Tom > > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of jjuser ud2 > Sent: Wednesday, January 28, 2009 1:06 PM > To: u2-users@listserver.u2ug.org > Subject: [U2][UD] Index for @ID (IBM documentation) > > Hi everybody, > > In the IBM publication "Developing UniBasic Applications", Version > 7.1, December 2006, it says on page 4-16 (page 93 in my PDF file): > > Tip: Create an index for @ID to speed access to data > records. > > Seriously? Will that honestly speed things up in a file that has > eight million records? > ------- > 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
