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 9:06 am

    #1652384

    bleroy (9/23/2013)

    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

    ooooh.. good idea! 🙂

    Exactly what I was looking for.. of course, I could just get 13 chars from the little table and see if there are any matches in the big table based on this.

    can't see the wood for the trees.. I will try this, thank you for the suggestion, seems so obvious now.

    D.