Hello I am trying to generate a list of monthly files backed up. I come up with the select statement below which seems to be taking it's time (not sure if it's legal). Does anyone know of a better way generate a summary of the total no. of files backed up
TIA Toni select count(contents.file_name), count(volumes.volume_name) from contents,volumes where volumes.volume_name=contents.volume_name and volumes.last_write_date = '2002-01-04 00:00'