Home Forums SQL Server 2012 SQL Server 2012 - T-SQL 108,000,000 row table - check for matches RE: 108,000,000 row table - check for matches

  • September 23, 2013 at 8:56 am

    #1652379

    What about adding 1 column to the small table that would contain RIGHT(smallTable.toid,13), create an index on that and then do your join?

    B