The following formula is used to determine the size of the SQL object in an SQL statement:

Formula

Size of the SQL object in an SQL statement = { 1,600 + 46 RCN + 394 Si + 24 Pi + 2,058 Ti + 76 Ti Di + 80 Ci + 40 Ii + 586 Wi + 24 Ki + Li + 8 TCi + 656 Di + 116 Ti QX + 28 QX + 200 Ai + 48 nFF + 100 nFP + 148 nFC + 712 nPFF + 32 (nAT + nPAT) + 20 nCAT + 28 (nAF + nCAF) + 20 (nAA + nPAA + nCAA) + 1,057 nSPA + 120 nSPP + 287 nSFF + 8 nSFP + 813 nJFC + 20 nJFP Add the result of this formula when using a trigger: + 1,057 nTR + 120 (nTSN + nTSO) + 20 (nTCN + nTCO) Add the result of this formula when using a referential constraint: + 760 + 376 RCC + 1,880 RCT Add the result of this formula when using a set operation: + 64 Ui Add the result of this formula when using matrix partitioning: + 16 Tmi + 16 Tmi Di Add the result of this formula when specifying a row value constructor: + 384 Wri + 32 QXs Add the result of this formula when using a check constraint: + 72 CDi + 88 Add the result of this formula when obtaining SQL runtime interim results: + 24 PIX + 192 Ti + 68 QX + 96 Add the result of this formula when specifying the LIMIT clause: + 160 Add the result of this formula when defining a falsification prevented table: + 200 Add the result of this formula when using the SET SESSION AUTHORIZATION statement: + 32 Add the result of this formula when obtaining transfer values from a list: + 32 ALP Add the result of this formula when using the XML type: + 36 Ti + 4,240 XQX + 8 XQX nURI Add the result of this formula when using a character set: + 80 TCCi + 88 sRi Add the result of this formula when using a sequence generator: + 168 nSQ Add the result of this formula when using the data compression facility: + 8 Ci + 32 nUOC + 28 Add the result of this formula when using temporary tables: + 200 nTT This is a computation formula for column name description area size. Add the result of this formula when using dynamic SQL: + 32 Si + 16 This is a computation formula for type name description area size. Add the result of this formula when using dynamic SQL: + (42 SiT) + {52 + 152 (SiTA + SiSA + SiNA) (SiT + SiS + SiN)} } 1,024

Notes

• If you use stored procedures or stored functions, also include the SQL statements described in the procedures or functions in the computation.
• If you use triggers, also include the SQL statements described in the triggers in the computation.
• If you use stored procedures, stored functions, or triggers, compute the size of the routine control object separately for the stored procedures, stored functions, or triggers, and add the result to the size of the SQL object buffer. The formula for computing the size of a routine control object is shown in (2) following.

(a) When the user defines a trigger

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

Size of the routine control object of a routine (in kilobytes) = { 600 + 28 sRi + 32 (sRUi + sDi) + 56 sSXi + sCUi + sSi + sPi + sLA + sKi + sL + 80 sWi + 24 sCM + 32 sCCR + 2 sDCR + 60 sCHD + 72 sDHD + 64 sHCN + 8 sCHD sHCN + 48 nRFF + 100 nRFP + 148 nRFC + 200 nPRFF + 8 nPRFP + 196 nPA + 64 nPP + 36 nPPI + 20 nPPO + 200 nPPA + 8 nPPP + 20 nAR + 48 nARA + 16 nRPAT + 20 nCAT + 28 (nRPAF + nRCAF) + 20 (nRPAA + nRCAA) + 287 nRSFF + 8 nRSFP + 813 nPJA + 20 nPJP + 813 nRJFC + 20 nRJFP Add the result of this formula when using a trigger: + 28 (nTSN 2 + nTSO) } 1,024

(b) When HiRDB automatically creates 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

Size of the routine control object of a routine (in kilobytes) = { 608 RCC + (5,120 + 100 RDi + 256 RIi) RCP RCT } 1,024

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 Also add the number of columns for which the following definition was specified during table definition (these columns might not be in the SQL statement): Columns for which DEFAULT is specified in the column definition Columns for which WITH DEFAULT is specified for a NOT NULL constraint specification
TCi	Number of table columns inside the SQL statement
Wi	Number of boolean operators inside the SQL statement#
Ki	Number of constants inside the SQL statement#
Li	Total size of the constants inside the SQL statement# (in 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)
QX	Number of query specifications
Ai	Total number of scalar operations in the SQL statement
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 invoked#
nFP	Total number of function arguments inside the SQL statement#
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 invoked#
nSFP	Total number of arguments for the system definition scalar functions inside the SQL statement#
nJFC	Number of times external Java functions are invoked inside the SQL statement
nJFP	Total number of arguments of external 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
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)
Ui	Number of set operations + 1
Tmi	Number of tables with matrix partitioning
Wri	Number of conditions using a row value constructor with two or more row value constructor elements specified
QXs	Number of table subqueries with multiple selection expressions specified
CDi	Number of check constraint conditions
PIX	Number of indexes used as multiple indexes
ALP	Number of receive functions for passing inter-function values from a list
XQX	Number of XQuery specifications
nURI	Number of XML name space URIs specified
TCCi	Number of columns with character set specification
nSQ	Number of sequence generators
nUOC	Number of UOCs used for data compression
nTT	Number of temporary tables
sRi	Number of SQL parameters inside procedures and functions (multiply the number of SQL parameters with the INOUT specification 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 external Java procedures are invoked inside the routine
nPJP	Total number of arguments for external Java procedures inside the routine
nRJFC	Number of times external Java functions are invoked inside the routine
nRJFP	Total number of arguments for external 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

#: When triggers are used, the trigger action conditions for the individual triggers that are activated by SQL statement execution must also be counted.