EF不使用SQL索引时用以过滤问题,怎么解决

2025-05-09 07:36:36
推荐回答(1个)
回答1:

试试先用语句删除重复的行.
delete from tb as a where id<>(select min(id) from tb as b where a.user=b.user and a.email=b.email )
然后再建唯一索引.