G
gus bjorklund
Guest
> On Dec 11, 2017, at 3:39 PM, Paul Koufalis wrote: > > Update from Progress Community > > Paul Koufalis > > OE 11.7 on AIX 6.1 > > Q1: Who is using partitioning in prod? If you prefer, please reach out to me in private. > > Q2: What are the programming gotchas? I know > > 1. RECIDs not usable > 2. Modifying the partiition-aligned keys could cause a record move/ROWID change > 3. Attempting to create a record outside a partition will fail (nowhere to put it) > 4. Partition field must be set at record creation > 1. Use ROWID instead. ROWID’s contain the partition id. RECID’s do not since they must be convertible to integers. 2. Yes. Changing the partition key of an existing record will cause the record to be deleted from its current partition and created in its new one. And all index entries have to be updated. And transaction log entries created and written. That’s just the nature of things. In well-designed partitioning schemes, this should not be an issue. 2a. You can take advantage of this behaviour to do "online table move”. 3. Yup. 4. All elements of partition key. And NULLs are not allowed. None of these things should be showstoppers.
Continue reading...
Continue reading...