Are these pages the reason why when I view the properties of a file in windows explorer there are two displays? One says "file size" and the other says "size on disk" (I don't remember exactly what they're called)
Kind of but not entirely. Files can be attached to other files in hidden partitions. The size on disk can sometimes be bigger than its size when there is another file that's attached, sometimes viruses use this to hide programming and/or even file backups like photos or videos the spyware is tracking incase you ever delete them
Why do you give examples with inserting rowid(5), then rowid(3), then rowid(10), for example. I usually assume that rows ids are actually inserted chronologically ordered i.e rowid(1), rowid(2), so forth, assuming ids are sequentially incremented. I that this has to be set while you creating the primary key of the table, but anyway it should exist, no? If not, is it realistic that row ids are created in a random manner like the examples you made, or is it just for illustration? I hope I am not totally understanding your talk the other way around 😄
kindly add a few pictures and diagram so it will be easy to understand the concept well instaed of showing off urself.. this is technical videos and not some chitchat... stop behaving like hollywood star.
