> Typical query > ------------ > > SELECT n.name > FROM node n > WHERE n.name > LIKE '56x%' > AND n.type='H' > AND n.usage='TEST' > AND n.node_id > NOT IN > (select n.node_id > FROM job_log j > INNER JOIN node n > ON j.node_id = n.node_id > WHERE n.name > LIKE '56x%' > AND n.type='H' > AND n.usage='TEST' > AND j.job_name = 'COPY FILES' > AND j.job_start >= '2005-11-14 00:00:00' > AND (j.job_stop <= '2005-11-22 09:31:10' OR j.job_stop IS NULL)) > ORDER BY n.name Do you have any indexes? regards Claus
