Definition

initial extent

The initial extent is a set of contiguous blocks in a database segment that is automatically allocated when the segment is created. Any set of contiguous blocks allocated after the initial extent is called a next extent. The total number of extents that can be allocated in a database is limited by the amount of storage space available, or in some cases, by the program used.

The term extent is sometimes used in reference to any contiguous space (for example, a set of sectors) on a hard drive that is reserved for a particular file, folder, or application.

This was last updated in September 2005

Dig Deeper on SQL Server Database Modeling and Design

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close