Question d’entretien chez HostBooks
How can we increase the performance of a SQL query in the SQL server?
Réponse à la question d'entretien
Utilisateur anonyme
9 févr. 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.