When I do sth like this I get weird behaviors depending on the ordering of the statements (e.g. exception when creating the DB schema complaining about duplicate index, or some index not being created, or multi-column index ending up having only one column) and I can't find a combination that does what it's supposed to do:
mapping.Map(x => x.ValuationTime).Index("idx_ValuationTime");
mapping.Map(x => x.CreationDate).Index("idx_CreateDate");
mapping.References(x => x.Status).Index("idx_Status");
mapping.Map(x => x.ValuationTime).Index("idx_all");
mapping.Map(x => x.CreationDate).Index("
idx_all");
mapping.References(x => x.Status).Index("
idx_all");
Has anyone tried having the same column being used in a mixture of single-column and multi-column indexes?