Menu

#4 inconsistent indices on featureprop.value

open
nobody
Chado DDLs (2)
5
2008-11-14
2008-11-14
No

Any idea why value is included in the clustered index for PostgreSQL and Sybase in the DDLs? The MySQL definition agrees with the GMOD table definition:

http://gmod.org/wiki/Chado_Sequence_Module#Table:_featureprop

MySQL:
CREATE UNIQUE INDEX uc1_featureprop ON featureprop (feature_id, type_id, rank);

PostgreSQL:
CREATE UNIQUE INDEX uc1_featureprop ON featureprop (feature_id, type_id, value, rank);

Sybase:
CREATE UNIQUE NONCLUSTERED INDEX uc1_featureprop ON featureprop (feature_id, type_id, value, rank);

Discussion

MongoDB Logo MongoDB