Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 1 7
Impact
~16k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Feb
27
awarded  Famous Question
Apr
24
awarded  Notable Question
Oct
3
awarded  Popular Question
Feb
5
awarded  Scholar
Feb
5
accepted Non-Clustered-Index on a temporary table
Jan
31
awarded  Editor
Jan
31
comment Non-Clustered-Index on a temporary table
updated my answer.
Jan
31
revised Non-Clustered-Index on a temporary table
added 47 characters in body
Jan
31
comment Non-Clustered-Index on a temporary table
@spagettidba: that is exactly what I am trying to say. My answer is not against the way Indexes work or prove indexes as faulty on Temp tables. Please read my answer again. I am talking about the approach and not specifically about the indexes.
Jan
31
comment Non-Clustered-Index on a temporary table
What about the time to rebuild the NCI on temp table every time the procedure is executed? I was talking about creating NCI dynamically after creation of temp table. It's a silly approach though but that's what I meant.
Jan
31
awarded  Commentator
Jan
31
comment Non-Clustered-Index on a temporary table
Ok, how come it took more time to execute the query after I added index to the temp table? Can you explain?
Jan
31
comment Non-Clustered-Index on a temporary table
I would like to see the explanation for down-vote. Why do people down-vote without any solid explanation? How is this answer misleading to anyone?
Jan
30
awarded  Analytical
Jan
30
answered Non-Clustered-Index on a temporary table
Jan
30
comment Non-Clustered-Index on a temporary table
@Alex: Yes, I can do that. But I need explanations on certain things and talk about it with experts. I suppose that's the primary reason why we visit Stack overflow. No?
Jan
30
awarded  Supporter
Jan
30
comment Non-Clustered-Index on a temporary table
Thanks for the info!
Jan
30
comment Non-Clustered-Index on a temporary table
Thanks for the info!
Jan
30
comment Non-Clustered-Index on a temporary table
@Jimbo: Sorry didn't get what you said. Please explain.