Re: sqlload performance
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 25 Jan 1995 14:29:20 GMT
Message-ID: <3g5n80$bro$1_at_mhadf.production.compuserve.com>
Date: 25 Jan 1995 14:29:20 GMT
Message-ID: <3g5n80$bro$1_at_mhadf.production.compuserve.com>
It has always been faster to drop the indexes, load the table, and then recreate the indexes after the table is loaded. This is true in just about any load situation in Oracle.
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Wed Jan 25 1995 - 15:29:20 CET