A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog

  Bookmark us:
  
  
  RSS:
  Add to Google
  translated in:
   
Web en.sybinfo.org

what's new (latest 20)
UnpinUnpin
sybmonsybmon
dbcc dbrebootdbcc dbreboot
Pluggable Component Interface (PCI)Pluggable Component Interface
keep countkeep count
lct_admin("lastchance")lct_admin("lastchance&quo
sp_displayrolessp_displayroles
sp_activerolessp_activeroles
locking schemelocking scheme
Stored ProceduresStored Procedures
TRIGGER EVENTTRIGGER EVENT
Virtual Page SizeVirtual Page Size
ALTER EVENTALTER EVENT
Joins: StrategiesJoins: Strategies
Join OperatorsJoin Operators
SubqueriesSubqueries
sa_enable_auditing_typesa_enable_auditing_type
sa_disable_auditing_typesa_disable_auditing_type
AuditingAuditing
sa_audit_stringsa_audit_string
internal
goto: contact
goto: disclaimer


Category: ASE: Data Storage

extents, extent

Adaptive Server pages can be allocated to a table, index or LOB structure. An extent is a block of eight consecutive pages. The page size specified when installing ASE therefore also determines the size of an extent.

Size of an extent

  • In a 2K-page ASE server an extent has a size of 16K.
  • In a 4K-page ASE server an extent has a size of 32K.
  • In a 8K-page ASE server an extent has a size of 64K.
  • In a 16K-page ASE server an exten has a size of 128K.

The smallest possible unit a table, index or other object can occupy is an extent, or eight pages.