14.2 SQL Hints

OFSBCE allows users to utilize SQL Hints to tune the performance of computation rules. SQL Hints provide a mechanism to instruct the optimizer to choose a desired query execution plan based on specified hint criteria. The Balance Computation engine reads user-defined hints that are stored in the FSI_OPTIMIZATION_SETTINGS in the SOURCE_HINT and the TARGET_HINT columns. The hints specified in SOURCE_HINT column are used applied during processing by the computation engine in the fetch part of the query. Similarly, TARGET_HINT column values are applied during processing to the insert/set part of the computation.