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: [email protected] [mailto:[email protected]] On Behalf Of jjuser ud2 Sent: Wednesday, January 28, 2009 1:06 PM To: [email protected] 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
