mysql - 加速/制作更高效的 SQL

Question

这是我的确切 SQL 代码，但它非常慢而且我知道这很糟糕......

有没有另一种方法可以做到这一点，但速度更快？

UPDATE Customer SET Title = "MR", SurName = "Test", FirstName ="Bob", HomePostCode ="SW18" WHERE CustomerID IN (SELECT CxID FROM Production WHERE policy_number = "001C5T" AND member_number = "100" AND family_group = "000001" AND CxID > 0)

谢谢

Answer 1

试试这个(未经测试)

UPDATE Customer c
JOIN Production p ON p.CxID = c.CustomerID
SET c.Title = "MR",
    c.SurName = "Test",
    c.FirstName ="Bob",
    c.HomePostCode ="SW18"
WHERE p.policy_number = "001C5T"
    AND p.member_number = "100"
    AND p.family_group = "000001"
    AND p.CxID > 0