Do not submit a query
unless you have some idea how long it will take!
It could tie up the server for hours (even days)!
Use select count(*) or select top
10 instead
Or try quick first, to see if it can be done
quickly
Do
use predefined views for commonly-used objects and parameters
PhotoObj, PhotoPrimary for
photometry
PhotoTag if you only need
popular fields
SpecObj for spectra