| Table Name | Index Type | Key or Field List |
| Best2Sector |
primary key | objid, regionID |
| Best2Sector |
foreign key | PhotoObjAll(objID) |
| Best2Sector |
foreign key | Sector(regionID) |
| Best2Sector |
covering unique index | regionID, objid |
| Chunk |
primary key | chunkID |
| Chunk |
foreign key | StripeDefs(stripe) |
| Convex |
primary key | regionid, convexid, constraintid |
| Convex |
foreign key | Region(regionid) |
| DataConstants |
primary key | field, name |
| DataConstants |
covering index | value |
| DBColumns |
primary key | tableName, name |
| DBColumns |
foreign key | DBObjects(name) |
| DBObjectDescription |
primary key | name |
| DBObjectDescription |
foreign key | DBObjects(name) |
| DBObjects |
primary key | name |
| DBViewCols |
primary key | viewName, name |
| DBViewCols |
foreign key | DBObjects(name) |
| Diagnostics |
primary key | name |
| ELRedShift |
primary key | elRedShiftID |
| ELRedshift |
foreign key | SpecObjAll(specObjID) |
| ELRedShift |
covering unique index | specObjID, elRedShiftID |
| Field |
primary key | fieldID |
| Field |
foreign key | Segment(segmentID) |
| Field |
covering index | field, camcol, run, rerun |
| Field |
covering index | run, camcol, field, rerun |
| FieldProfile |
primary key | fieldID, bin, band |
| FieldProfile |
foreign key | Field(fieldID) |
| FileGroupMap |
primary key | tableName |
| FileGroupMap |
foreign key | PartitionMap(fileGroupName) |
| First |
primary key | objID |
| First |
foreign key | PhotoObjAll(objID) |
| Frame |
primary key | fieldID, zoom |
| Frame |
foreign key | Field(fieldID) |
| Frame |
covering index | field, camcol, run, zoom, rerun |
| Frame |
covering index | htmID, zoom, cx, cy, cz, a, b, c, d, e, f, node, incl |
| Glossary |
primary key | [key] |
| History |
primary key | version |
| HoleObj |
primary key | HoleID |
| HoleObj |
foreign key | PlateX(plateID) |
| IndexMap |
primary key | indexmapid |
| IndexMap |
foreign key | DBObjects(name) |
| LoadHistory |
primary key | loadVersion, tStart |
| Mask |
primary key | maskID |
| Mask |
covering index | htmID, ra, dec, cx, cy, cz |
| MaskedObject |
primary key | objid, maskid |
| MaskedObject |
foreign key | PhotoObjAll(objID) |
| MaskedObject |
foreign key | Mask(maskID) |
| Match |
primary key | objID, matchObjID |
| Match |
foreign key | PhotoObjAll(objID) |
| MatchHead |
primary key | objID |
| MatchHead |
foreign key | PhotoObjAll(objID) |
| Neighbors |
primary key | objID, NeighborObjID |
| Neighbors |
foreign key | PhotoObjAll(objID) |
| ObjMask |
primary key | objID |
| ObjMask |
foreign key | PhotoObjAll(objID) |
| PartitionMap |
primary key | fileGroupName |
| PhotoObjAll |
primary key | objID |
| PhotoObjAll |
foreign key | Field(fieldID) |
| PhotoObjAll |
covering index | mode, cy, cx, cz, htmID, type, flags, status, ra, dec, u, g, r, i, z, rho |
| PhotoObjAll |
covering index | htmID, cx, cy, cz, type, mode, flags, status, ra, dec, u, g, r, i, z, rho |
| PhotoObjAll |
covering index | field, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z |
| PhotoObjAll |
covering index | fieldID, objID, ra, dec, r, type, status, flags |
| PhotoObjAll |
covering index | SpecObjID, cx, cy, cz, mode, type, flags, status, ra, dec, u, g, r, i, z, rho |
| PhotoObjAll |
covering index | cx, cy, cz, htmID, mode, type, flags, status, ra, dec, u, g, r, i, z, rho |
| PhotoObjAll |
covering index | run, mode, type, status, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z |
| PhotoObjAll |
covering index | run, camcol, rerun, type, mode, status, flags, ra, dec, fieldID, field, u, g, r, i, z |
| PhotoObjAll |
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 |
| PhotoProfile |
primary key | objID, bin, band |
| PhotoProfile |
foreign key | PhotoObjAll(objID) |
| PhotoTag |
primary key | objID |
| PhotoTag |
foreign key | PhotoObjAll(objID) |
| PhotoTag |
foreign key | Field(fieldID) |
| PhotoTag |
covering index | mode, cy, cx, cz, htmID, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size] |
| PhotoTag |
covering index | htmID, cx, cy, cz, type, mode, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size] |
| PhotoTag |
covering index | field, run, rerun, camcol, type, mode, flags, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z |
| PhotoTag |
covering index | fieldID, objID, ra, [dec], modelMag_r, type, status, flags |
| PhotoTag |
covering index | SpecObjID, cx, cy, cz, mode, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size] |
| PhotoTag |
covering index | cx, cy, cz, htmID, mode, type, flags, status, ra, [dec], modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, [size] |
| PhotoTag |
covering index | run, mode, type, status, flags, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z, modelMagErr_u, modelMagErr_g, modelMagErr_r, modelMagErr_i, modelMagErr_z |
| PhotoTag |
covering index | run, camcol, field, rerun, type, mode, status, flags, ra, [dec], fieldID, modelMag_u, modelMag_g, modelMag_r, modelMag_i, modelMag_z |
| PlateX |
primary key | plateID |
| PlateX |
covering index | htmID, ra, dec, cx, cy, cz |
| ProfileDefs |
primary key | bin |
| QsoCatalogAll |
primary key | zone, ra, SpecObjID, bestObjID, targetObjID |
| QsoConcordance |
primary key | zone, ra, dec, specObjID, bestObjID, targetObjID |
| Region |
primary key | regionid |
| RegionConvexString |
primary key | regionid, convexid |
| RegionConvexString |
foreign key | Region(regionid) |
| Rmatrix |
primary key | mode, row |
| Rosat |
primary key | objID |
| Rosat |
foreign key | PhotoObjAll(objID) |
| SDSSConstants |
primary key | name |
| Sector |
primary key | regionId |
| Sector |
foreign key | Region(regionID) |
| Sector2Tile |
primary key | regionId, tile |
| Sector2Tile |
foreign key | Sector(regionID) |
| Sector2Tile |
foreign key | TileAll(tile) |
| Sector2Tile |
covering unique index | tile, regionID |
| Segment |
primary key | segmentID |
| Segment |
foreign key | Chunk(chunkId) |
| Segment |
foreign key | StripeDefs(stripe) |
| SiteConstants |
primary key | name |
| SiteDiagnostics |
primary key | name |
| SpecLineAll |
primary key | specLineID |
| SpecLineAll |
foreign key | SpecObjAll(specObjID) |
| SpecLineAll |
covering unique index | specobjID, specLineID |
| SpecLineIndex |
primary key | specLineIndexID |
| SpecLineIndex |
foreign key | SpecObjAll(specObjID) |
| SpecLineIndex |
covering unique index | specobjID, speclineindexID |
| SpecObjAll |
primary key | specObjID |
| SpecObjAll |
foreign key | PlateX(plateID) |
| SpecObjAll |
covering index | htmID, ra, dec, cx, cy, cz, sciencePrimary |
| SpecObjAll |
covering index | BestObjID, objType, objTypeName, sciencePrimary, specClass, htmID, ra, dec, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z |
| SpecObjAll |
covering index | specClass, zStatus, zWarning, z, sciencePrimary, primTarget, secTarget, plateId, bestObjID, targetObjId, htmID, ra, dec |
| SpecObjAll |
covering index | targetObjID, objType, objTypeName, sciencePrimary, specClass, htmID, ra, dec, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z |
| SpecPhotoAll |
primary key | specObjID |
| SpecPhotoAll |
foreign key | SpecObjAll(specObjID) |
| SpecPhotoAll |
covering index | objID, sciencePrimary, specClass, z, targetObjid, targetId |
| SpecPhotoAll |
covering index | targetObjID, sciencePrimary, specClass, z, objid, targetId |
| SpecPhotoAll |
covering index | targetID, sciencePrimary, specClass, z, objid, targetObjId |
| StripeDefs |
primary key | stripe |
| Target |
primary key | targetID |
| Target |
covering index | bestobjID, regionID, specobjid |
| Target |
covering index | specobjID, regionID, bestobjID |
| Target |
covering index | regionID, bestobjid, specobjid |
| Target |
covering index | htmID, ra, dec, cx, cy, cz |
| TargetInfo |
primary key | skyVersion, targetID |
| TargetInfo |
foreign key | Target(targetID) |
| TargetInfo |
covering index | targetobjID, primTarget, secTarget, priority |
| TargetInfo |
covering unique index | targetID, skyversion, targetobjID |
| TargetParam |
primary key | targetVersion, name |
| TileAll |
primary key | tile |
| TileAll |
foreign key | TilingRun(tileRun) |
| TileAll |
covering unique index | tileRun, tile |
| TileAll |
covering index | htmID, racen, deccen, cx, cy, cz |
| TileContains |
primary key | tileID, regionID |
| TiledTargetAll |
primary key | targetID, tile |
| TiledTargetAll |
foreign key | TileAll(tile) |
| TiledTargetAll |
covering unique index | tile, targetID |
| TiledTargetAll |
covering index | htmID, ra, dec, cx, cy, cz, objtype |
| TiledTargetAll |
covering unique index | objType, targetID, tile |
| TilingGeometry |
primary key | tilingGeometryID |
| TilingGeometry |
foreign key | TilingRun(tileRun) |
| TilingGeometry |
foreign key | StripeDefs(stripe) |
| TilingInfo |
primary key | tileRun, targetID |
| TilingInfo |
foreign key | TilingRun(tileRun) |
| TilingInfo |
covering unique index | targetID, tileRun, collisionGroupID |
| TilingInfo |
covering unique index | tileRun, collisionGroupID, targetID |
| TilingInfo |
covering index | tile, collisionGroupID |
| TilingNote |
primary key | tilingNoteID |
| TilingNote |
foreign key | TilingRun(tileRun) |
| TilingRun |
primary key | tileRun |
| USNO |
primary key | objID |
| USNO |
foreign key | PhotoObjAll(objID) |
| XCRedshift |
primary key | xcRedshiftID |
| XCRedshift |
foreign key | SpecObjAll(specObjID) |
| XCRedshift |
covering unique index | specObjID, xcRedShiftID |
| Zone |
primary key | zoneID, ra, objID |
| Zone |
foreign key | PhotoObjAll(objID) |
