For information on the variables used in the formulas, see (3) following.
The following formula is used to determine the size of the SQL object in an SQL statement:
Formula
|
1 Add the result of this formula when specifying a foreign table.
2 Add the result of this formula when using a trigger.
3 Add the result of this formula when using a referential constraint.
4 Computation formula for column name description area size. Add the result of this formula when using dynamic SQL.
5 Computation formula for type name description area size. Add the result of this formula when using dynamic SQL.
When the user defines a stored procedure, a stored function, or a trigger, the following formula is used to determine the size of the routine control object of a routine:
Formula
|
* Add the result of this formula when using a trigger.
When HiRDB creates a trigger for constraint control when CASCADE is specified for the referential action during table definition, the following formula is used to determine the size of the routine control object of a routine:
Formula
|
Variable name | Explanation |
---|---|
RCN | Total number of tables and indexes used by the SQL object |
Si | Number of retrieval items inside the SQL statement (number of columns if the columns specified by the SQL statement are index columns) |
Pi | Number of embedded variables or parameters inside the SQL statement |
Ti | Number of table names inside the SQL statement |
Ci | Number of column names inside the SQL statement |
TCi | Number of table columns inside the SQL statement |
Wi | Number of boolean operators inside the SQL statement1 |
Ki | Number of constants inside the SQL statement1 |
Li | Total size of the constants inside the SQL statement1(units: bytes) |
Ii | Number of indexes used during SQL statement execution (number of indexes specified as retrieval conditions in the table specified by the SQL statement) |
Di | Total number of storage conditions defined in the table inside the SQL statement (times 2 for a matrix-partitioned table) |
SiT | Number of abstract data types in the selection expression inside the SQL statement |
SiS | Number of supertypes for the abstract data types in the selection expression inside the SQL statement |
SiN | Total number of supertypes for the abstract data type, which is a subtype of the selection expression inside the SQL statement |
SiTA | Number of attributes for the abstract data types in the selection expression inside the SQL statement |
SiSA | Number of attributes of the supertypes for the abstract data types in the selection expression inside the SQL statement |
SiNA | Total number of components specified for the abstract data type, which is a subtype of the selection expression inside the SQL statement |
nSPA | Number of times the procedure statements inside the SQL statement are invoked |
nSPP | Total number of arguments for the procedure statements inside the SQL statement |
nFF | Number of times the functions inside the SQL statement are invoked1 |
nFP | Total number of function arguments inside the SQL statement1 |
nFC | Total number of function definition candidates for the functions inside the SQL statement (number of function invocations nFF + number of function definitions that use as arguments the subtypes to the function invocations whose arguments are abstract data types) |
nPFF | Number of times the plug-in functions used by SQL objects are invoked (1 for the number of plug-in function invocations inside the SQL statement + SELECT; 6 for INSERT, UPDATE, or DELETE) |
nSFF | Number of times the system definition scalar functions inside the SQL statement are invoked1 |
nSFP | Total number of arguments for the system definition scalar functions inside the SQL statement1 |
nJFC | Number of times the Java functions inside the SQL statement are invoked |
nJFP | Total number of arguments of the Java functions inside the SQL statement |
nAT | Number of abstract data types used by component specification inside the SQL statement (excluding the abstract data types that are manifested by supertypes and abstract data type attributes) |
nAA | Number of abstract data types used by component specification inside the SQL statement (including the abstract data types that are manifested by supertypes and abstract data type attributes) |
nAF | Total number of attributes used by component specification inside the SQL statement |
nPAT | Number of abstract data types used by the arguments of the plug-in functions used by the SQL object (excluding the abstract data types that are manifested by supertypes and abstract data type attributes) |
nPAA | Number of abstract data types used by the arguments of the plug-in functions used by the SQL object (including supertypes and subtypes) |
nCAT | Number of times the constructor functions inside the SQL statement are invoked |
nCAA | Number of abstract data types of the constructor functions inside the SQL statement (including supertypes) |
nCAF | Total number of attributes of the abstract data types of the constructor functions inside the SQL statement |
nFT | Number of foreign tables inside the SQL statement |
nFTS | Size of the SQL statement that retrieves foreign tables2 |
nFTQ | Number of embedded variables or parameters inside the SQL statement that retrieves foreign tables2 |
nTR | Number of triggers that are activated by SQL statement execution |
nTSN | Total number of columns modified by the new values correlation name inside the trigger SQL statement of each trigger activated by SQL statement execution |
nTSO | Total number of columns modified by the old correlation name inside the trigger SQL statement of each trigger activated by SQL statement execution |
nTCN | Total number of columns modified by the new values correlation name inside the trigger action condition of each trigger activated by SQL statement execution |
nTCO | Total number of columns modified by the old correlation name inside the trigger action condition of each trigger activated by SQL statement execution |
RCC | Total number of member columns of the foreign key and the primary key of the table that references the update-target table inside the SQL statement |
RCT | Total number of tables that reference the update-target table and the number of tables that the update-target table references inside the SQL statement |
RCP | Total number of cascades specified for referencing actions during referencing table definition |
RIi | Total number of indexes defined for referenced tables that are specified for referencing during referencing table definition |
RDi | Total number of partitioning storage conditions defined for referenced tables that are specified for referencing during referencing table definition (to be multiplied by 2 for a matrix partitioning table) |
sRi | Number of SQL parameters inside procedures and functions (Count for SQL parameter with INOUT specification should be multiplied by 2). |
sRUi | Total number of SQL parameters inside procedures and functions (or the total number of columns modified by an old or new values correlation name inside the trigger SQL statement inside trigger definition) |
sDi | Number of SQL variables (declare) inside procedures, functions, and trigger SQL statements |
sSXi | Total number of SQLCODE and SQLCOUNT variables inside procedures, functions, and trigger SQL statements |
sCUi | Total number of CURRENT_TIME and CURRENT_DATE constants inside procedures, functions, and trigger SQL statements |
sSi | Number of data manipulation SQL statements inside procedures and trigger SQL statements (SQL statements excluding cursor declaration: OPEN, FETCH, CLOSE, UPDATE, DELETE, and INSERT statements, for example) |
sPi | Number of routine control SQL statements inside procedures, functions, and trigger SQL statements (BEGIN, SET, IF, ELSE IF, and WHILE, for example) |
sLA | Number of labels inside procedures, functions, and trigger SQL statements |
sKi | Number of constants inside procedures, functions, and trigger SQL statements (excluding the constants of data manipulation SQL statements described inside procedures and trigger SQL statements) |
sL | Combined total size of the constants inside procedures, functions, and trigger SQL statements (excluding the constants of data manipulation SQL statements described inside procedures and trigger SQL statements) |
sWi | Number of condition predicates inside procedures, functions, and trigger SQL statements |
sCM | Number of compound statements inside procedures, functions, and trigger SQL statements |
sCCR | Number of compound statements that describe cursor declarations for procedures and trigger SQL statements |
sDCR | Number of cursor declarations for procedures and trigger SQL statements |
sCHD | Number of compound statements that describe handler declarations for procedures, functions, and trigger SQL statements |
sDHD | Number of handler declarations for procedures, functions, and trigger SQL statements |
sHCN | Number of condition values described inside handler declarations for procedures, functions, and trigger SQL statements |
nRFF | Number of function invocations inside the routine |
nRFP | Total number of function arguments inside the routine |
nRFC | Total number of function definition candidates for the functions inside the routine (number of function invocations nFF + number of function definitions that use as arguments the subtypes to the function invocations whose arguments are abstract data types) |
nPRFF | Number of times the plug-in functions used by SQL objects of the routine are invoked |
nPRFP | Total number of plug-in parameters of the plug-in functions used by the SQL objects of the routine |
nPA | Number of procedure invocations inside the routine |
nPP | Total number of parameters for the procedures inside the routine |
nPPI | Total number of input parameters for the procedures inside the routine (including input/output parameters) |
nPPO | Total number of output parameters for the procedures inside the routine (including input/output parameters) |
nPPA | Number of times the plug-in procedure used by the SQL objects of the routine is invoked |
nPPP | Total number of plug-in parameters of the plug-in procedure used by the SQL objects of the routine |
nRSFF | Number of times the system definition scalar functions inside the routine are invoked |
nRSFP | Total number of arguments for the system definition scalar functions inside the routine |
nPJA | Number of times the Java procedures inside the routine are invoked |
nPJP | Total number of arguments for the Java procedures inside the routine |
nRJFC | Number of times the Java functions inside the routine are invoked |
nRJFP | Total number of arguments for the Java functions inside the routine |
nAR | Number of abstract data types used by component specification inside the routine (excluding the abstract data types that are manifested by supertypes and abstract data type attributes) |
nARA | Total number of attributes used in component specification inside the routine |
nRPAT | Number of abstract data types used by the parameters of the plug-in routines used by the SQL objects of the routine (excluding the abstract data types of supertypes and abstract data type attributes) |
nRPAA | Number of abstract data types used by the parameters of the plug-in routines used by the SQL objects of the routine (including supertypes) |
nRPAF | Total number of attributes of the abstract data types used by the parameters of the plug-in routines used by the SQL objects of the routine |
nRCAT | Number of times the constructor functions inside the routine are invoked |
nRCAA | Number of abstract data types of the constructor functions inside the routine (including supertypes) |
nRCAF | Total number of attributes of the abstract data types of the constructor functions inside the routine |