Post reply

using IN and a list of values

  • December 5, 2003 at 6:13 pm

    #484949

    I am still curious about your 75 Million rows

    I would like to know the performance of the query posted using sp_excecutesql @STR with the hard coded numbers in @STR. My guess is that for such a big table a recompilation of the procedure using harcoded numbers will be the fastest option!

    can you post the results?


    * Noel

  • December 8, 2003 at 6:38 am

    #485066

    I will post them noeld as soon as I get some time next week. I will be on training all week.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply