Expression of String type that defines Oracle SQL hint.
It is used as an instruction for the performance optimizer of SQL
command. The value is used without the opening and
terminating characters /*+ <orahint>
*/.
The example is mentioned
here.
Table must be opened with the access _DB_MODIFY. There must be the
correct structure type of inserted row or structure. Values of all
items of every inserted row must be valid.
The advantage of the action DBS_INSERT at work
with a table is the possibility to leave out its closing and opening
(shorter code).
For D2000 v5.00: an disadvantage of the action DBS_INSERT
is in speed. Each DBS_INSERT call results in necessity
to open and close the database in DBManager - it can be a
time-consuming operation and it is a comparatively nonstandard method
in term of databases.
The need to open and close the database may
be avoided in the scope of transaction processing so that the
command is followed by the parameter
TRANS
.
For D2000 v6.00 and higher: DBManager
optimization (connection
recycling, predefined connections) causes, that the action DBS_INSERT is
executes as quick as the action DB_INSERT and as
moreover there is saved a time required for execution of the action
DB_CONNECT to open the database.
0 komentárov