update TBL_SQZL
set HYJG = 1
where ID = (
select ID
from (
select ID
from TBL_SQZL
where JYTGM is not null
and XM = '郭玉珍'
and ZJHM = '310101194307254025'
and ZJLX = '01'
order by CRT_TIMESTAMP desc)
where ROWNUM = 1
);
select准确查出一条数据,整体执行的时候就一直转圈圈……表数据有两万四千多条,是需要优化还是怎么滴?