INDICES FOR TABLE  PhotoAuxAll

These are added as a separate table because adding columns to the very large PhotoObjAll table is prohibitively expensive unless the table is reloaded from scratch. In a future release, these columns will be added to the PhotoObjAll table. In the meantime, to access these columns, you may join with the PhotoObjAll table on the objid: SELECT p.objid, p.ra, q.raErr, p.dec, q.decErr FROM PhotoObjAll p, PhotoAuxAll q WHERE p.objid = q.objid Similarly you may join the PhotoObj and PhotoAux views.

Index Type	Key or Field List
primary key	objID
foreign key	PhotoObjAll(objID)
covering index	mode, l, b, raErr, decErr, raDecCorr
covering index	l, b, objID, mode
covering index	b, l, objID, mode