Appendix A. Indexes Added To Chado

Table of Contents

Indexes On ANALYSIS
analysis_idx1b on ANALYSIS.Type_Id
analysis_bc1 on ANALYSIS.Name (Unique)
Indexes On FEATURE
feature_idx1b on FEATURE.Feature_Id, FEATURE.DBXref_Id
Indexes On FEATURE_RELATIONSHIP
feature_relationship_idx1b on FEATURE_RELATIONSHIP Object_Id, Subject_Id, Type_Id
Indexes On FEATURELOC
featureloc_idx1b on FEATURELOC Feature_Id, FMin, FMax

Babase has added indexes to Chado to improve performance.

These are listed separately in an appendix since they do not directly impact the function of the database.

Indexes on mulitple keys are in the order given.


Page generated: 2021-09-27T09:55:53-04:00.