Table of Contents Previous Next


2 SQL Tutorial : 2.4 Optimizer Hints : 2.4.6 Using the APPEND Optimizer Hint

By default, Advanced Server will add new data into the first available free-space in a table (vacated by vacuumed records). Include the APPEND directive after an INSERT or SELECT command to instruct the server to bypass mid-table free space, and affix new rows to the end of the table. This optimizer hint can be particularly useful when bulk loading data.
Note that Advanced Server supports the APPEND hint when adding multiple rows in a single INSERT statement:
The APPEND hint can also be included in the SELECT clause of an INSERT INTO statement:

2 SQL Tutorial : 2.4 Optimizer Hints : 2.4.6 Using the APPEND Optimizer Hint

Table of Contents Previous Next