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>


: : 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 VCS
Received on Mon Jul 25 1994 - 05:51:08 CEST

Original text of this message