2.6 How are rows of SQL tables stored in dbefiles?
Key points
A DBEFile can contain data for many SQL tables. The illustration shows
that rows for Table A are stored on
DBEFile 0, pages 1 and 2.
DBEFile 1, pages 3 and 4.
DBEFile 2, pages 1 and 254.
Rows for Table B are stored on
DBEFile 0, page 3.
DBEFile 1, pages 1, 2 and 254.
DBEFile 2, page 3.
Each data page of a DBEFile only contains rows for a single table. For
example, page 1 of DBEFile 0 can only contain rows for Table A. If all of
the rows on a page are deleted, the page can be used to hold data for a
different table.
Printable version
