WSA_UkidssViews.sql

This script creates the required indices for release databases and curation purposes. The script is coded as a set of T-SQL batches so this script can be manually played on the load server through Query Analyser. Additionally, curation application codes can read this script, parse it for the indices created and use this information to enable individual index drop/create calls as well as a complete index creation run (i.e. CU18).

allFrameSets	View of all defined frame sets within the archive
dxsFrameSets	View of all frame sets defined for the UKIDSS DXS
dxsJKmergeLog	View of DXS frame sets having JK passband coverage
dxsJKsource	Provides DXS sources in areas having JK passband coverage
gcsFrameSets	View of all frame sets defined for the UKIDSS GCS
gcsPointSource	Merged, seamless point source catalogue derived from the UKIDSS GCS
gcsZYJHKmergeLog	View of GCS frame sets having complete (ZYJHK) passband coverage
gcsZYJHKsource	Provides GCS sources in areas having complete (ZYJHK) passband coverage
gpsFrameSets	View of all frame sets defined for the UKIDSS GPS
gpsJHKmergeLog	View of GPS frame sets having complete (JHK) passband coverage
gpsJHKsource	Provides GPS sources in areas having complete (JHK) passband coverage
gpsPointSource	Merged, seamless point source catalogue derived from the UKIDSS GPS
lasExtendedSource	Merged, seamless extended source catalogue derived from the UKIDSS LAS
lasFrameSets	View of all frame sets defined for the UKIDSS LAS
lasPointSource	Merged, seamless point source catalogue derived from the UKIDSS LAS
lasYJHKmergeLog	View of LAS frame sets having complete (YJHK) passband coverage
lasYJHKsource	Provides LAS sources in areas having complete (YJHK) passband coverage
reliableDxsSource	Reliable, but incomplete, source catalogue derived from UKIDSS DXS
reliableGcsPointSource	Reliable, but incomplete, point source catalogue derived from UKIDSS GCS
reliableGpsPointSource	Reliable, but incomplete, point source catalogue derived from UKIDSS GPS
reliableLasPointSource	Reliable, but incomplete, point source catalogue derived from UKIDSS LAS
reliableUdsSource	Reliable, but incomplete, source catalogue derived from UKIDSS UDS
udsFrameSets	View of all frame sets defined for the UKIDSS UDS
UKIDSSDetection	All UKIDSS subsurvey detections appear in this view.
Latest Revision:	11931, 2017-11-30 11:31:03 (Thu, 30 Nov 2017)