Page Concept in SQL

 

 

data is stored in the form of table. But internally data is stored in many pages.  So above data of a table can be stored in multiple pages like page number one, page number two, page number three and so on.

If the table has more data or more number of rows, there will be more number of pages for that particular table.

the size of the page is 8 KB i.e. 8192 bytes.

 

Each Page has a page header and an offset of the page.

• Page Header has reference of Previous and Next page
• Page offset store how far the row is from the start of the page. it keep record of each row in that page