June 23, 2025 at 12:00 am
Comments posted to this topic are about the item Using Heaps
June 24, 2025 at 2:44 pm
I have also used heaps when the data has no real business value but someone requested the data to be captured because it may be needed one day by someone. Things like an audit table where someone someday may want to look at the data in there, but the table is almost exclusively used for inserts and selects happen very infrequently. And for demos. Did a demo ages back showing how a HEAP is much faster for inserts and for very very small tables, selects and updates were basically the same from a timing perspective. But once you have enough data that the table is interesting (which doesn't even need to be that many rows) or you start joining it to other tables, heaps are rather slow.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply