SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  LIST_STORAGE_AREA
    Specifies the name of the storage area to be used for table
    columns defined through SQL with the LIST OF BYTE VARYING data
    type.

    You can specify the LIST STORAGE AREA parameter for multifile
    databases only.

    By default, columns with the LIST OF BYTE VARYING data type are
    stored in the RDB$SYSTEM storage area. If you specify a different
    storage area in this clause, the CREATE DATABASE statement must
    include a CREATE STORAGE AREA clause defining that area. For
    information about creating multiple list storage areas for a
    table, see the CREATE STORAGE_AREA clause.

                                   NOTE

       If you plan to store lists with segments of widely varying
       sizes, you should specify a MIXED page format area just
       for list storage. (Do not assign tables and indexes to the
       area.)

       The database system looks for free space in an area when it
       stores each segment of a segmented string. If size varies
       significantly among the different segments of the lists
       that you plan to store, the interval and threshold values
       that the database system automatically sets for page format
       areas you specify as UNIFORM can make storing lists time-
       consuming. For a mixed page format area, you can customize
       interval and thresholds values to reduce the amount of time
       that the database system spends looking for free space when
       it stores different segments of the same segmented string.

    The following example shows valid syntax for the LIST STORAGE
    AREA clause:

    SQL> CREATE DATABASE FILENAME test
    cont> LIST STORAGE AREA IS registry_area
    cont>    CREATE STORAGE AREA RDB$SYSTEM FILENAME maintenance_area
    cont>    CREATE STORAGE AREA registry_area FILENAME registry_area;
    SQL> CREATE STORAGE MAP registry_map
    cont> STORE LISTS IN registry_area;
Close Help