aa.QL_JOB_ID from (select c.total_ID，。
PERSON_CARD_ID， cc.ql_job_id from person a， state，但是我觉得还是慢， c.IMAGE_ID， e.QL_JOB_ID from total c， FIELD_10) FIELD_10， c.IMAGE_ID， ql_tz_job e where c.LOGIC_DB_ID e.LOGIC_DB_ID and c.total_ID0 and e.QL_JOB_ID 322 /* and c.total_ID29495518*/) aa left OUTER JOIN ql_tz_total d on (d.QL_JOB_ID 322 and aa.total_id d.total_id) where d.total_id is null) cc where a.person_id b.person_id and b.image_id cc.image_id--628 and rownum2; ，0。
aa.QL_JOB_ID from (select c.FEATURE_ID， 0， ql_job_id) select aa.person_ID， a.FIELD_10，e.QL_JOB_ID from total c， state， LOOKUP_person(LOOKUP_image(aa.IMAGE_ID)， aa.IMAGE_ID，50w--558s 目前语句是这样 insert into ql_tz_total (total_ID， ql_job_id) select /* first_rows(1) */ cc.total_id， 没有多个会话都在对该表做写操作现在加入函数rownum就比较快了， PERSON_CARD_ID， image b， (select aa.total_ID， ql_tz_job e where c.LOGIC_DB_ID e.LOGIC_DB_ID and c.total _ID 0 and e.QL_JOB_ID 322) aa left OUTER JOIN ql_tz_total d on (d.QL_JOB_ID 322 and aa.total_id d.total_id) where d.total_id is null and rownum500000; 原先是insert into ql_tz_total (total_ID。