Previous Page | Next Page

SAS/ACCESS Interface to Oracle

Maximizing Oracle Performance

There are several measures you can take to optimize performance when using SAS/ACCESS Interface to Oracle. For general information about improving performance when using SAS/ACCESS engines, see Performance Considerations.

SAS/ACCESS Interface to Oracle has several options that you can use to further improve performance.

If you choose the transactional inserting of rows (specify BULKLOAD=NO), you can improve performance by inserting multiple rows at a time. This performance enhancement is comparable to using the Oracle SQL*Loader Conventional Path Load. For more information about inserting multiple rows, see the INSERTBUFF= option.

Previous Page | Next Page | Top of Page