The size of the view analysis information buffer for a single view table can be found from the following formulas. See (2) and (3) for details about the variables used in the formulas.
Formula for HiRDB in 32-bit mode
|
Formula for HiRDB in 64-bit mode
|
Determine LPTREE from the following formulas. See (3) for details about the variables used in the formulas.
Formula for HiRDB in 32-bit mode
|
Formula for HiRDB in 64-bit mode
|
Variable name | Explanation |
---|---|
LCNST | Total size of the constants resulting from adding the following expressions:#1, #2, #3
|
NINCC |
|
NINCP |
|
NQRY | Number of queries in the view definition |
NSBQ | Number of subqueries in the view definition |
NSTOP | Number of set operations in the view definition |
NSLST | Total selection items for all query specifications in the view definition#4 |
NWHRC | Number of WHERE clauses in the view definition |
NGPHV | Number of GROUP BY clauses in the view definition + Number of HAVING clauses in the view definition |
NVLCM | Number of comparison predicates in the view definition + Number of quantified predicates in the view definition |
NEXCM | Number of IN predicates in the view definition |
NNLCM | Number of NULL predicates in the view definition |
NRANG | Number of BETWEEN predicates in the view definition |
NLKCM | Number of LIKE and XLIKE predicates in the view definition |
NSMCM | Number of SIMILAR predicates in the view definition |
NETCM | Number of EXISTS predicates in the view definition |
NRVCL | Number of row value constructor elements in the view definition |
NTVCL | Number of row value constructor elements on the right side of IN predicates in the view definition |
NLGEX | Number of logical operators in the view definition |
NCNST | Total number of constants in the view definition + Total number of pattern characters in the view definition |
NSREG | Total number of USER value functions, CURRENT DATE value functions, CURRENT TIME value functions, and CURRENT TIMESTAMP value functions in the view definition |
NPRCS | Number of CURRENT TIMESTAMP decimal seconds precision specifications in the view definition |
NCSCV | Number of constants subject to character set conversion in the view definition#2 |
NARTH | Total number of arithmetic, date, and time operations in the view definition |
NCNCT | Number of concatenation operations in the view definition |
NLBLD | Number of labeled durations in the view definition |
NSFNC | Number of set functions in the view definition |
NSCLF | Number of system built-in scalar functions in the view definition |
NFCSP | Number of function invocations or scalar functions in the view definition |
NCLM | Total number of columns in the view definition |
NCASE | Number of CASE expressions in the view definition + Number of NULLIF CASE abbreviations in the view definition |
NWHEN | Number of WHEN CASE expressions in the view definition + 1 |
NCSSP | Number of CAST specifications in the view definition |
NPOS | Number of system built-in POSITION scalar functions in the view definition |
NDTV | Number of system built-in scalar functions (DATE, TIME, TIMESTAMP, or VARCHAR_FORMAT) in the view definition |
NEXTR | Number of system built-in scalar functions (YEAR, MONTH, DAY, HOUR, MINUTE, or SECOND) in the view definition |
NSBST | Number of system built-in SUBSTR scalar functions in the view definition |
NVALU | Number of system built-in VALUE scalar functions in the view definition + Number of COALESCE CASE abbreviations in the view definition |
NBTEX | Number of system built-in BIT_AND_TEST scalar functions in the view definition |
NCAST | Number of system built-in scalar functions (INTEGER or DECIMAL) in the view definition |
NOPTL | Number of SQL optimization specifications in the view definition |
NOPTJ | Number of joined format SQL optimization specifications in the view definition |
NOPTT | Number of table SQL optimization specifications in the view definition |
NOPTIX | Number of index SQL optimization specifications in the view definition |
NSLAS | Number of select expression AS clauses in the view definition |
NJTBL | Number of joined tables in the view definition |
NCSET | Number of types of character sets that can be specified by HiRDB + 1#5 |
NSPDT | Number of AS data-type specifications in the view definition |
NFPRM | Total number of function invocation arguments and system-defined scalar function arguments in the view definition |
NRTNL | Total number of functions potentially invoked by function invocations and functions potentially invoked by system-defined scalar functions in the view definition |
NEXRTN | Total number of external routines among functions that could potentially be invoked in the view definition |
NCLASS | Total number of JAVA function classes in the view definition |
NJAR | Total number of JAVA function JAVA archives in the view definition |
NPVOW | Total number of public view owner names in the view definition |
NDTBL | Number of FROM clause derived tables in the view definition + Number of view tables that generate internal derived tables in the view definition |
NTBL |
|
NDCLM | Total number of columns of FROM clause derived tables in the view definition + Total number of columns of view tables that generate internal derived tables in the view definition |
NVCLM | Number of columns derived by the view definition |
NVCSC | Number of columns derived by the view definition that specify a character set other than the default character set |
NADTL | Number of all abstract data types in the view definition, including those in inheritance relationships#6 |
NATTL | Number of component specifications in the view definition |
NATNM | Number of attribute names of all component specifications in the view definition |
NPLGL | Number of functions provided by plug-ins in the view definition |
NPPRL | Number of parameters of functions provided by plug-ins in the view definition |
NCUD | Number of abstract data type columns in the view definition |
Constant type | Size (bytes) | Maximum size required by boundary adjustment (bytes) |
---|---|---|
Integer constant | 4 | 7 |
Decimal constant | ![]() ![]() ![]() | ![]() ![]() ![]() |
Floating-point numeric literal | 8 | 15 |
Character string constant | 2 + character string constant character count | 2 + character string constant character count + 3 |
Hexadecimal constant | 4 + (hexadecimal constant character string length) ![]() | 4 + (hexadecimal constant character string length) ![]() |
National character string literal | 2 + national character string literal character count![]() | 2 + national character string literal character count![]() |
Mixed character string literal | 2 + mixed character string literal single-byte character count + mixed character string literal double-byte character count![]() | 2 + mixed character string literal single-byte character count + mixed character string literal double-byte character count![]() |