Jun-23-2019, 11:43 AM
I know several ways to speed up SQL query. I would advise you to try the following:
1. Review the execution elan
2. Ensure that all joins are leveraging indexes
3. Try to join on data types such as integers rather than text-based data types such as varchar or nvarchar
1. Review the execution elan
2. Ensure that all joins are leveraging indexes
3. Try to join on data types such as integers rather than text-based data types such as varchar or nvarchar