D2000 DBManager - performance tuning

Oracle SQL Hints

Oracle SQL Hints are used to pass instructions, or hints, to the performance optimizer of SQL statement.

Syntax:

	SELECT /*+ <orahint> */ ...
	UPDATE /*+ <orahint> */ ...
	DELETE /*+ <orahint> */ ...
	INSERT /*+ <orahint> */ ...

In ESL script actions, the value is used without the opening and terminating characters /*+, */.

Example of use:

 ;with APPEND the rows are written directly to the datafiles and are not logged
 
 DBS_INSERT DB.AR_USER_PRAVO_TEMP, _Temp, _retCode ORAHINT "append"
 IF _retCode # _ERR_NO_ERROR THEN
 CALL [E.AR] LogError((%GetLastExtErrorCode())) ASYNC ON AR.EVH 
 ENDIF

You can find more information in Oracle documentation.

Napíšte komentár