Hi, All. I have an update query where in it causes a 98 percent CPU Skew. The core table has good PI and not skewed. but when i joined to a NON PI table. The CPU SKEW arises.
Can anyone here simplify this query?
Try using UPSERT instead of UPDATE and COALESCE or DEFAULT (table level) instead of CASE.