• It looks like cardinality estimation error. Please update statistics WITH FULLSCAN on DataSource and Trade tables.

    Also in the original query you can try to replace

    INNER JOIN dbo.DataSource ON dbo.DataSource.DataSourceID=dbo.Trade.DataSourceID

    with

    LEFT JOIN dbo.DataSource ON dbo.DataSource.DataSourceID=dbo.Trade.DataSourceID


    Alex Suprun