Table Report

• Folder (field DOSSIER)

Define the folder code, as it is defined in the folders table, in which the work will be carried out.

• Table (field FICHIER)

Name of the table where the characteristics are given.

The rule is as follows :

• the tables describes in the dictionary and present in the database are displayed first, sorted in the alphabetic order.
• then, the table SYS_LOB table, which stores all the fields of the type BLOB or CLOB (in the case of an Oracle database).
• finally, all the tables present in the database, but not described in the dictionary, they are also sorted alphabetically.

• Description (field NOMFIC)

Title associated with the previous code.

• Number of lines (field NBREC)

Define the real number of lines in the table (to be compared with the planned number of lines).

• Expected number (field NBPRE)

Define the number of lines expected during the dimensioning of the table.

• Ratio (field RATIO)

• Size (K-bytes) (field TAILLE)

Define the total size taken by the table (in Kb). This is the sum of the data and index size.

For an Oracle database, it does not include the size of the clobs, stored separately in the SYS_LOB table.

• Table extensions (field EXTDAT)

This information is only displayed when the database is Oracle. It gives the number of extents in the table.

• Index extensions (field EXTIDX)

This information is only displayed when the database is Oracle. It gives the number of extents in the index.

• Index number (field NBIDX)

Define the number of indexes create in the table.

• Table size (field TAILDAT)

Define the size taken by the data in the table in Kb.

For an Oracle database, the size of the BLOB/CLOB fields is excluded, because these fields are stored in the SYS_LOB table.

• Index size (field TAILIDX)

Define the size (in Kb) taken by all the indexes created in the table.

• Maximum extensions (field MAXIDX)

This information is only displayed when the database is Oracle. It gives the maximum number of extents found by index.

• Not used (field UNUSED)

This information is only displayed when the database is SQLServer. It gives the size (in Kb) reserved and not used for the table and its indexes.

• No. of fields (field NBFLD)

Define the number of fields (in the Adonix sense, a dimensioned field counts as one) in the table.

• No. of columns (field CLFLD)

Defining the number of columns in the table in the database. This number is in general greater that the number of fields, because an Adonix dimensioned field is counted as a field, but is defined as N columns in the database.

• Length (field LGFLD)

Define the length of the record.

• Image file (field BLOB)

Maximum size (in Kb) of the blobs managed in the table (when a field of this type exists in the table).

• Anomaly (field TEXTEANO)

When an anomaly is found in a table, the corresponding line is displayed in color (the color depends on the gravity of the anomaly).

The anomalies that exist are :

• anomaly of type 1 : the number of lines in the table is greater that 3 times that planned at the start. The relation between the two is given in the text for anomaly.
• anomaly of type 2 : the number of extents on the data or the index exceeds 30.
• anomaly of type 3 : number of colors too great or the size (on integrating the blobs) is too large.

These anomalies are likely to pose performance problems.

• Total folder size (field TAILTOT)

Define the total used by the tables in the folder.

• field COMMENT2

• field COMMENT3

• Size of the base (field TAILBASE)

Total size of the current database, all folders included. This size includes all the data files and journal files.

• field MB1

• Space not allocated (field ESPACE)

Database space that has not been reserved for the database objects.

• field MB2

• Total size (field TOTAL)

Total quantity of space allocated by the objects in the database.

• field MB3

• Data (field DONNEES)

Total quantity of space occupied by the data.

• field MB4

• Index (field INDEX)

Total quantity of space occupied by the indexes.

• field MB5

• Not used (field UNUSED)

Total quantity of space reserved for the objects in the database, but not yet used.

• field MB6

• No. (field NUMLIG)

• Tablespace (field TABLESP)

Located in this column are the Oracle tablespaces name present to manage the data in the folder.

• Free space (MB) (field FRESPA)

Define the space remaining free (in Mb) in each tablespace.

• Space taken (Mb) (field USED)

Define the space occupied (in Mb) in each tablespace.