1.

What are the different ways to optimize a MySQL query?

Answer»
  • Don't USE "sp_" while creating a stored procedure.
  • Don't use "*" while you are USING the SELECT command. Also avoid unnecessary columns in SELECT clause.
  • You can use table aliases while writing queries.
  • Avoid the usage of the wildcard (%) at the starting of a predicate.
  • DISTINCT and UNION NEED to be USED solely if it is necessary.


Discussion

No Comment Found

Related InterviewSolutions