Don’t use the * in your queries. A SELECT * creates a overload on table, Input/Output and network bandwidth.
All columns involved in indexes should appear on WHERE and JOIN clauses on the same sequence they appear on index.
Avoid VIEWs. Use them only when there are benefits of doing so.
Verify if a critical query gains performance by turning it in a stored procedure.
All columns involved in indexes should appear on WHERE and JOIN clauses on the same sequence they appear on index.
Avoid VIEWs. Use them only when there are benefits of doing so.
Verify if a critical query gains performance by turning it in a stored procedure.
