Hi Baker Well as you probably know the partitioning needs to be based on the key, so it depends upon what meaningful information you can store there in an invariant way.
For example: If they are coming from archive, do/could the keys have an originating date component? If so, you can distribute easily across yearly or quarterly files by creating a partitioning expression that is simply: ThatDateComponentAsAYear - StartYear (or with added quarters) Brian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Baker Hughes > Sent: 26 May 2009 22:00 > To: '[email protected]' > Subject: [U2] Best algorithm for UV part files > > Does anyone have an opinion about the best algorithm to use > for UV distributed files? > > The goal is ease of moving the records in the distributed > files to other files. > > There may be other criteria by which to gauge the best DF > strategy, but in this case I'm just working with restored > archive records, and moving records here and about. > > Regards, > -Baker > > > This communication, its contents and any file attachments > transmitted with it are intended solely for the addressee(s) > and may contain confidential proprietary information. > Access by any other party without the express written > permission of the sender is STRICTLY PROHIBITED. > If you have received this communication in error you may not > copy, distribute or use the contents, attachments or > information in any way. Please destroy it and contact the sender. > ------- > 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/
