130 reputation
17
bio website
location
age
visits member for 1 year, 9 months
seen Oct 31 '13 at 21:00

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.
Jan
30
comment Non-Clustered-Index on a temporary table
The difference I am trying to understand is in terms of cost to re-build the index on actual table vs temp table. How does the rebuild work on physical table vs temp table? DBA's uneasiness is with creating index on existing physical table which is because this table is a high traffic table with 100s of records consistently coming in every few seconds.