Sql, Data, Data Engineering, Programming, Data Science.
WHERE date >= "2022-01-01" Avoid using Function-based conditional clause: When a query uses a function in the WHERE or JOIN clause on the column, it would not utilize the index, hence slowing down the execution. -- WHERE date(ship_date) = '2022–01–01' -- JOIN T2 ON CONCAT(first_name,' ',last_name)