Sql, Data, Data Engineering, Programming, Data Science.
columns of type DOUBLE or FLOAT, as this may lead to unexpected behavior due to rounding & precision issues. Minimize use of SELF Joins: Self joins are computationally more expensive and can be replaced with Window function in many cases. Don’t join tables with OR condition: It can be optimized by