heap Image

heap

question
Jeff Moden avatar image
Jeff Moden answered Default

Does a clustered index make insertions slower than if the table is a heap?

performance sqlserver clustered-index heap

0 Likes

2Answers

0 Comments

question
GPO avatar image
GPO edited Default

Unmatched estimated no of rows and sub tree cost

execution-plan heap estimated-rows

This question has an accepted answer. Accepted

2 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey answered Default

Xplan for a query: Performance Issue

query heap

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Heap index fragmentation

sql heap

2 Likes

2Answers

2 Comments

question
skpani avatar image
skpani edited Default

index_id getting changed

index nonclustered-index table partition heap

1 Like

0Answers

0 Comments

question
Pamz avatar image
Pamz answered Default

Best approach to delete first 5 million rows from a heap in batches

sql-server delete batch heap

This question has an accepted answer. Accepted

1 Like

2Answers

0 Comments

6 Posts
6 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.