Extent is a basic unit of storage to provide space for tables. Every extent has a number of data pages. As new records are inserted new data, pages are allocated. There are eight data pages in an extent. So as soon as the eight pages are consumed, it allocates a new extent with data pages.
While extent is basic unit storage from a database point of view, page is a unit of allocation within extent.
Asked In: Many Interviews |