Sql, Data, Data Engineering, Programming, Data Science.
does not utilize an index, and the database is tasked with searching all records for a match anywhere within the selected field. Hence, if needed prefer to use wildcards at the end of a phrase only. SELECT user_name FROM test WHERE user_name LIKE '%abc%' Use WHERE instead of HAVING: Prefer usage of