The database administrator should also examine the structure of the various locations on the system and the databases defined within each location with an eye towards reducing unnecessary or redundant data storage. The XDB Server supports distributed processing at various levels. See the chapter Storage Architecture for more information about the system architecture.
The system catalog tables provide information about the tables in a database. To determine the space occupied by a given table or index, use the directory DIR (Windows) or ls (UNIX) command from your operating system prompt to list the tables in a given directory. The directory DIR (Windows) or ls (UNIX) command lists the amount of space occupied by each file in addition to the number of free bytes remaining on the disk. You can use the SQL SELECT command to query any of the system catalog tables. See the SQL Reference for a description of the SELECT command. See the chapter Storage Requirements for more information about estimating data storage requirements.