Simon Riggs wrote:
My hope is to have a mechanism to partition indexes or recognise that they are partitioned, so that a set of provably-distinct unique indexes can provide the exact same functionlity as a single large unique index, just without the management nightmare.
Will this address the fairly common data design problem where we need to ensure that a given value is unique across several tables (possibly siblings, possibly not)? If so, then full steam ahead.
cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings