79203767

Date: 2024-11-19 14:18:09
Score: 2
Natty:
Report link

Make sure that the columns used in your WHERE clause have indexes.

Ensure date column is using the correct format amd ensure that SQL Server isn't performing a type conversion that could affect the performance.

You can also add an ORDER BY clause and ensure it has a index.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Vaibhav