What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query t

Q

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”?

✍: Guest

A

Answer1.
Use Storedprocedure for any optimized result, because it is an compiled code.

Answer2.
One of the best ways to increase query performance is to use indexes.

2014-10-10, 1626👍, 0💬