At 02:02 AM 26/03/2004 +0100, you wrote:

>hi all,
>
>i know that FB have some problems with index with lot of duplicated
>values...
>
>I want to as what happen when i create composed index like:
>ArticleID, Container
>
>where ArticleID is unique for each container and there is relatively few
>possible containers...
>
>Is there difference if index is composed in another order like
>Container, ArticleID ???

Yes.

>Will there be same performance penalty like with single column index
>with lot of duplicates???

No: it's a unique index, so there are no duplicate chains.

/heLen