Ignore:
Timestamp:
02/18/17 13:46:29 (8 years ago)
Author:
Daniela Dorner
Message:
optimized status/processing queries and settings
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/DataCheck/Setup/steps_fact_isdc.rc

    r17062 r18760  
    4747Callisto.MainTable: Callisto
    4848Callisto.Primaries: fNight, fSequenceID
    49 Callisto.Needs: RawFileAvailISDC SequenceFileAvailISDC
    50 Callisto.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
     49#Callisto.Needs: RawFileAvailISDC SequenceFileAvailISDC
     50Callisto.Needs: SequenceFileAvailISDC
     51#Callisto.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID) LEFT JOIN SequenceInfo USING(fNight, fSequenceID)
     52Callisto.SpecialJoin: LEFT JOIN SequenceInfo USING(fNight, fSequenceID)
     53Callisto.SpecialWhere: AND fNumRuns=fNumRawfilesAvailISDC
    5154
    5255Star.MainTable: Star
    5356Star.Primaries: fNight, fSequenceID
    5457Star.Needs: RawFileAvailISDC Callisto DriveFileAvailISDC RatesFileAvailISDC SequenceFileAvailISDC
    55 Star.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
     58Star.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID) LEFT JOIN SequenceInfo USING(fNight, fSequenceID)
    5659
    5760#Merpp.MainTable: Merpp
Note: See TracChangeset for help on using the changeset viewer.