Skip to content
«
»
 

Create Index on Table Variable

Posted by 
on  November 23 2009

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Create Index on Table Variable”.

Filed under SQL
Comment (RSS)  |  Trackback  |  Permalink

8 Comments

  1. Ed Graham says:
    January 18, 2012 at 6:16 am

    Fantastic tip, particularly after I read on StackOverflow that it couldn’t be done. My query involving an inner join on a table without a PK went from 3m 23s to 17s!

    Reply to this comment
  2. Julianne says:
    September 23, 2011 at 11:07 am

    Great Derek! Thanks for the tip:)

    Reply to this comment
  3. Julianne says:
    September 23, 2011 at 11:06 am

    Greate Derek!

    Reply to this comment
  4. Daniel N says:
    August 24, 2011 at 12:28 am

    Awesome tip, my query batch went from 7 minutes down to 12 seconds.

    Reply to this comment
  5. Adam says:
    July 25, 2011 at 1:53 am

    Blimy, this optimised my stored procedure. It took it down from 6 mins to 22 seconds. Thank you.

    Reply to this comment
  6. George says:
    April 2, 2010 at 4:58 am

    Thanks Derek. A unique composite constraint helped drop the execution time of my sproc by half.

    Reply to this comment
  7. Twitted by SSISBI says:
    November 23, 2009 at 10:39 pm

    [...] This post was Twitted by SSISBI [...]

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»