Using a Fill Factor in an Index

As you insert, you crete a new page. Once you reach 80 % of that page, stop, don't use it any more. If you have random inserting values right in the page, things like goids, like oide that are actually random, or even into ger bers that you know it's random, it's going to be coming in random fashion. Then having a fill factor of 80% is all subjective and really depends on, i guess, use cases and testing and trial and error. I'm going to talk about, we have to sometimes the filth actors actually a twoa double eged,. 'm ging to come to that in a minute,

Transcript

Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.