INDICES FOR TABLE  SpecPhotoAll

The combined spectro and photo parameters of an object in SpecObjAll

This is a precomputed join between the PhotoObjAll and SpecObjAll tables. The photo attibutes included cover about the same as PhotoTag. The table also includes certain attributes from Tiles.

Index TypeKey or Field List
primary keyspecObjID
foreign keySpecObjAll(specObjID)
covering indexobjID, sciencePrimary, specClass, z, targetObjid, targetId
covering indextargetObjID, sciencePrimary, specClass, z, objid, targetId
covering indextargetID, sciencePrimary, specClass, z, objid, targetObjId