SPD Server
uses four types of component files. Component files are physical file
entities that SPD Server uses to track table and index metadata. Component
files, when combined, form a logical structure that SPD Server understands
and interprets as a single table. The relative sizes of the four types
of SPD Server component files are:
File Type File extension Relative size Number of
component files
-----------------------------------------------------------------------
Table Metadata .mdf Very small 1
Table Data .dpf Large 1 to many
Segmented Index(es) .idx Medium to Large 0 or more
Global Index(es) .hbx Medium to Large 0 or more