weixin_44364949-优快云博客

原创 111111

SELECT C1.product_cd,I1.finish_datetime,C1.mecha_no,serial_no,A1.team_cd,A1.process_cd,H1.parts_cd,H1.parts_name_chn,count(h1.parts_cd) as QTY,I1.LotNo,‘’ as ‘result’,I1.remark,‘’ as ‘JigNo’,(select top 1 worker_id from T_worker_result as f where c1.mecha

2022-08-16 17:03:38 63

原创优化索引结果

啊实打实

2022-08-16 16:35:38 58

原创优化结果4

select xx.product_cd, xx.finish_datetime, xx.mecha_no, xx.serial_no, xx.team_cd, xx.process_cd, xx.parts_cd,xx.parts_name_chn, xx.QTY, xx.LotNo, xx.result, xx.remark, xx.JigNo, xx.worker_id from ( select distinct c1.product_cd, i1.finish_datetime, c1.mecha

2022-08-16 16:07:14 54

原创优化结果3

select xx.product_cd, xx.finish_datetime, xx.mecha_no, xx.serial_no, xx.team_cd, xx.process_cd, xx.parts_cd,xx.parts_name_chn, xx.QTY, xx.LotNo, xx.result, xx.remark, xx.JigNo, xx.worker_id from ( select distinct c1.product_cd, i1.finish_datetime, c1.mecha

2022-08-16 15:18:39 71

原创优化结果2

select distinct c1.product_cd, i1.finish_datetime, c1.mecha_no, c1.serial_no, a1.team_cd, a1.process_cd, h1.parts_cd, h1.parts_name_chn, count(h1.parts_cd) as QTY, i1.parts_lot as ‘LotNo’, ‘’ as ‘result’, i1.remark, ‘’ as ‘JigNo’, (select top 1 worker_id f

2022-08-16 15:16:57 77

原创测试优化结果

select distinct c1.product_cd, i1.finish_datetime, c1.mecha_no, c1.serial_no, a1.team_cd, a1.process_cd, h1.parts_cd, h1.parts_name_chn, count(h1.parts_cd) as QTY, i1.parts_lot as ‘LotNo’, ‘’ as ‘result’, i1.remark, ‘’ as ‘JigNo’, (select top 1 worker_id f

2022-08-16 15:11:46 94

原创 SQL优化，下面这条

这种sql优化方案有哪些

2022-08-16 11:02:33 147 1

mainnewsql.sql

2024-12-13

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人