Pregunta de entrevista de HostBooks
How can we increase the performance of a SQL query in the SQL server?
Respuesta de la entrevista
Anónimo
9 feb 2019
Avoid using GROUP BY, ORDER BY, and DISTINCT. Use SET NOCOUNT ON, Do not use the * operator in your SELECT statements. Instead, use column names. Always prefix object names (i.e. table name, stored procedure name, etc.) with its owner/schema name.