Back to the original question - is there any table hint that will maximize Insert performance in this situation? Maybe there is none.
A heap is not even considered a table, so don't expect miraculous table hints.
Place the heap on a separate disk device (if any) for best performance.
Performance tuning: http://ift.tt/1dBfMua
You may consider adding a clustered index (and PK) to control it like a table.
Kalman Toth Database & OLAP Architect SQL Server 2014 Design & Programming
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
No comments:
Post a Comment