Subject | composed Index |
---|---|
Author | Pavol STÁREK PSŽ |
Post date | 2004-03-26T01:02:58Z |
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 ???
Will there be same performance penalty like with single column index
with lot of duplicates???
Thanx for answers...
Pavol Starek
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 ???
Will there be same performance penalty like with single column index
with lot of duplicates???
Thanx for answers...
Pavol Starek