Re: How to insert data fast
From: Ian Parkin <iap_at_scammell.ecos.tne.oz.au>
Date: Mon, 25 Jul 1994 03:51:08 GMT
Message-ID: <1994Jul25.035108.8085_at_scammell.ecos.tne.oz.au>
Date: Mon, 25 Jul 1994 03:51:08 GMT
Message-ID: <1994Jul25.035108.8085_at_scammell.ecos.tne.oz.au>
: : Q3,What should I do to speed up data insert other than Q1,Q2 ?
: Yes, you can turn off redo logging in V7 - I cant remember the init.ora
: parameter, take a look at x$ksppi, it has all the undocumented
: init.ora params you can play with.
It may be quicker if you disable any indexes and constraints prior to the insert and then re-enable.
IAP
-- I'd rather drink my own urine than use VCSReceived on Mon Jul 25 1994 - 05:51:08 CEST