You create a cache using the Create Cache statement (refer to "Create Cache (EXT)" in the DataDirect Connect Series for ODBC Reference). A cache can be created on a single table or on a set of related tables. When creating a cache on a single table, you specify the name of the table to cache and can optionally specify a filter for the table. The filter determines whether the cache holds all of the data in the remote table or a subset of the data that matches the filter. You can also specify attributes for the Create Cache statement that determine: