meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 4 months |
| seen | Feb 5 at 19:56 | |
| stats | profile views | 0 |
|
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. |
|
Jan 30 |
asked | Non-Clustered-Index on a temporary table |
|
Jan 25 |
awarded | Student |
