What is the meaning of Low Value and High Value for column statistics? (From DBMR1813)
You can see column statistics in JDBA Tool.
For example:
dmSQL> create table test(a serial);
dmSQL> insert into test values();
1 rows inserted
dmSQL> insert into test values();
1 rows inserted
dmSQL> insert into test values();
1 rows inserted
dmSQL> insert into test values();
1 rows inserted
dmSQL> select * from test;
A
===========
1
2
3
4
4 rows selected
For the sample, in JDBA, you can see the following statistics data for columns:
Column |
#of Distinct values |
Average Length |
Low Value |
High Value |
A |
4 |
4 |
2 |
3 |
So they are statistics values for column,
Low-value (loVal) means the second minimum value for a column;
High-value (hiVal) means the second maximum value for a column;
So in this case, Low Value is 2 and High Value is 3.
The maximum and minimum value is filtered by Statistics, so low-value and high-value will use the second maximum and minimum value.