INDICES FOR TABLE  PhotoObjAll

The table has views: PhotoObj: all primary and secondary objects; essentially this is the view you should use unless you want a specific type of object. PhotoPrimary: all photo objects that are primary (the best version of the object). Star: Primary objects that are classified as stars. Galaxy: Primary objects that are classified as galaxies. Sky:Primary objects which are sky samples. Unknown:Primary objects which are no0ne of the above PhotoSecondary: all photo objects that are secondary (secondary detections) PhotoFamily: all photo objects which are neither primary nor secondary (blended) The table has indices that cover the popular columns.

Index Type	Key or Field List
primary key	objID
foreign key	Field(fieldID)
covering index	mode, cy, cx, cz, htmID, type, flags, status, ra, dec, u, g, r, i, z, rho
covering index	htmID, cx, cy, cz, type, mode, flags, status, ra, dec, u, g, r, i, z, rho
covering index	htmID, run, camcol, field, rerun, type, mode, flags, status, cx, cy, cz, g, r, rho
covering index	field, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z
covering index	fieldID, objID, ra, dec, r, type, status, flags
covering index	SpecObjID, cx, cy, cz, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
covering index	cx, cy, cz, htmID, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
covering index	run, mode, type, status, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z
covering index	run, camcol, rerun, type, mode, status, flags, ra, dec, fieldID, field, u, g, r, i, z
covering index	run, camcol, field, mode, parentID, q_r, q_g, u_r, u_g, isoA_r, isoB_r, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z
covering index	run, camcol, type, mode, cx, cy, cz
covering index	ra, [dec], type, mode, flags, u, g, r, i, z, psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z, primTarget