请问一条SQL语句的性能问题 - MS-SQL Server / 基础类

SQL code:


DECLARE @i int
SET @i = 0
UPDATE table1 SET @i = @i + 1, id = @i WHERE id > @i AND id IN (SELECT TOP 100 PERCENT id from table1 ORDER BY id)




该语句实现 重新序列化id使id成为重1开始的连续记录, 而不改变记录的相对id的排序位置,使
id name
7 1
3 2
2 3
6 4

序列化后
id name
4 1
2 2
1 3
3 4

请问大家这语句有没有性能问题,,或者有没有更好的方法

---

SQL code:
with cte as(
select *,row_id=row_number() over(order by id) from table1
)

update cte
set id=row_id

---

update tb
set id = (select count(1) from tb where id < t.id) + 1 
from tb t

---

SQL code:
create table tb(id int,name varchar(10))
insert into tb values(7 ,'1')
insert into tb values(3 ,'2')
insert into tb values(2 ,'3')
insert into tb values(6 ,'4')
go

update tb
set id = (select count(1) from tb where id < t.id) + 1
from tb t

select * from tb

drop table tb

/*
id name
----------- ----------
4 1
2 2
1 3
3 4

（所影响的行数为 4 行）

*/

{