Hiroshi Inoue wrote:
> > At the end of the day though, the reason is only performance. The
> > semantics should be the same no matter whether implemented as multiple
> > indexes or not. Performance is much better with one index though.(*)
> >
>
> Is it true ?
> How to guarantee the uniqueness using multiple indexes ?
Well you'd have to check every index in the hierarchy. As I said,
inefficient.