April 8, 2017 at 7:03 am
what is unique extent, and mixed extent?
April 8, 2017 at 8:23 am
Uniform extent: Its 8 pages are reserved and used by only one object
Mixed extent: Its pages are shared by multiple objects (data, indexes). The maximum number of objects that can use one extent is eight.
Igor Micev,My blog: www.igormicev.com
April 22, 2017 at 12:27 am
There is no such Unique extent !
Extents are logical units for data storage in database. They are combination of 8 data pages i.e. 64 KB.
Extents can be of two types UNIFORM and MIXED.
Uniform Extent - These types of extenct are dedicated to hold data pages for only one type of objects.
Mixed extent - These type of extent can hold different type of data pages like Index, System , Data pages etc.
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply