Why is the APPEND hint so great? In a prior post, we extolled the virtues of the APPEND hint (AKA Direct Path Insert). It is a great option to use • UNDO usage is negligible. It is only generated for index maintenance and meta data changes. The keyword is index maintenance – indexes generate UNDO. … Continue reading Oracle – Is my APPEND Hint Being Ignored? How To Find Out?
Oracle's logical storage structures: To developers who work with Oracle, the concept of tablespace is familiar. We create tables and indexes in tablespaces taking appropriate care not to place all of our data into one tablespace. Let us take a quick look at the logical structure of an Oracle database A database has one or … Continue reading Oracle’s APPEND Hint – The Key Secret To Fast BULK Loading With NOLOGGING!