Home Forums SQL Server 7,2000 Performance Tuning CAST Issue on join Creating index scan - poor performance RE: CAST Issue on join Creating index scan - poor performance

  • November 13, 2013 at 2:57 pm

    #1666222

    What's the reason for the CAST conversion?

    It seems like o.invoiceid is already a character data type. What exact data type are the two columns referenced in the join predicate (o.invoiceid and t.invoicedid)? What does the actual execution plan look like?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]