Extents are basic unit in which space is allocated to table or indexes.An extent is 8 contiguous pages .Each page is having size of 8k.
Subscribe to:
Post Comments (Atom)
-
When SQL Server executes a query it uses a query plan to determine how to access data and complete the query. SQL Server offers DBAs and d...
No comments:
Post a Comment