To use databases optimally, you have to understand the different database objects supported by Microsoft SQL Server Compact. You also have to understand the different data types that are used to create tables.
Describes the various database objects and their sizes.
Describes the different data types that can populate SQL Server Compact databases.
Describes temporary databases in SQL Server Compact.