Task #549

Updated by Aaron Marcuse-Kubitza over 11 years ago

* include cascading (indirect) fkeys 

 * query to add covering index: 
 <pre> 
 CREATE INDEX ON table (field); 
 </pre> 

 h3. Fkeys' covering indexes 

 |*Table*|*Field*|*Covering index*| 
 |aggregateoccurrence|source_id|aggregateoccurrence_source_id_idx| |aggregateoccurrence|source_id| _*none*_| 
 |commclass|classpublication_id| _unused_| 
 |commconcept|reference_id| _unused_| 
 |commdetermination|commauthority_id| _unused_| 
 |commname|source_id| _unused_| 
 |commstatus|source_id| _unused_| 
 |coordinates|source_id|coordinates_unique| 
 |covermethod|source_id| _unused_| 
 |location|source_id|location_creator| 
 |locationevent|source_id|locationevent_source_id_idx| |locationevent|source_id| _*none*_| 
 |method|source_id|method_unique| 
 |party|source_id|party_source_id_idx| |party|source_id| _*none*_| 
 |place|source_id|place_unique_within_creator_by_name| 
 |plantobservation|source_id|plantobservation_source_id_idx| |plantobservation|source_id| _*none*_| 
 |project|source_id|project_source_id_idx| |project|source_id| _*none*_| 
 |sourcecontributor|source_id| _unused_| 
 |sourcelist|source_id|sourcelist_unique| 
 |sourcename|matched_source_id|sourcename_matched_source_id_idx| |sourcename|matched_source_id| _*none*_| 
 |specimenreplicate|source_id|specimenreplicate_source_id_idx| |specimenreplicate|source_id| _*none*_| 
 |stemobservation|source_id|stemobservation_source_id_idx| |stemobservation|source_id| _*none*_| 
 |taxonconcept|concept_reference_id| _unused_| 
 |taxondetermination|source_id|taxondetermination_source_id_idx| |taxondetermination|source_id| _*none*_| 
 |taxondetermination|reference_id| _unused_| 
 |taxonlabel|source_id|taxonlabel_source_id_idx| |taxonlabel|source_id| _*none*_| 
 |taxonoccurrence|source_id|taxonoccurrence_source_id_idx| |taxonoccurrence|source_id| _*none*_| 
 |taxonstatus|source_id| _unused_| 

 generated from the messages output by 
 <pre> 
 DROP TABLE source CASCADE; 
 </pre>

Back