Hi Don. Forgot to mention that table partition by date.
On Wed, May 31, 2017 at 11:19 AM, Don Seiler <don@xxxxxxxxx> wrote:
You can have locally partitioned unique indexes, you just need to include
the partition key in them.
Don.
On Wed, May 31, 2017 at 1:09 PM, Vadim Keylis <vkeylis2009@xxxxxxxxx>
wrote:
Good morning. We have table that is partition using interval partition.
Older partition will be dropped on regularly. What is the best practice to
enforce uniqueness across partitions considering that global index is not
an option since it becomes invalid once partition is dropped?
Thanks so much in advance,
Vadim
--
Don Seiler
www.seiler.us
