10 % of data for all datasets to work more efficiently

[Patrick]

@AnnaNZ

That's a simple syntax error. You've missed a comma.

h1.defineKey('REFER_ID', 'CL_ID');

406        h1.defineKey('REFER_ID' 'CL_ID');
                                   -------
                                   22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=,
              <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||,
              ~=.

[kiranv_]

When ever queryoptimization is needed, what I would do is see how each query works, which part of query is running slow and try to find why it i running slow and how can I enhance query performance. With proper techniques, lot of queries can be optimized. Say building indexes can help, a hash join could be better or a join by format. There could be many more techniques