Subject Re: [firebird-support] composed Index
Author Helen Borrie
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
>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 ???


>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.