How does the DBMaker find free page if the present page is full when an insert command is executed?

~ 0 min
2016-03-07 04:45

DBMaker will keep previous inserted page id (hint page) internally, when next insert
SQL executes, DBMaker will find out this page to insert first, if the page space is not enough then it try to find out next page to insert. For example, if previous inserted page id is 200, and someone execute insert command, DBMaker will insert data at page 200 first, if the 200 page have no enough space, DBMaker will scan next page (201) to find free space for inserting by sequential. If still does not find out free space to insert till the end of tablespace, it will jump begin of tablespace to scan to find out free page.

Average rating 0 (0 Votes)

You cannot comment on this entry