query taking long time to match

Vineet S 185 Reputation points

Hi Team,

how to split the query to check data missmatch fint.eabl column if there multiple left joint and taking time to match it

query attached

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bruce (SqlWork.com) 57,891 Reputation points

    when you use a function (substring, ltrim, rtrim, dateadd, etc) on a column in the join or where clause, that value can not be used to index, a scan is done. if the other columns are not very selective, this will cause a table scan and slow the query.

    outer joins are typically slow as its all rows not matching the join.

    note: you should clean up your data and not require trim operations.