[EMAIL PROTECTED] (Aldor) writes: > I'm curious how other people do it: > > What is faster? > > 1. CREATE TABLE > 2. restore data > 3. CREATE INDEX > > or > > 1. CREATE TABLE > 2. CREATE INDEX > 3. restore data
Creating the index AFTER loading the data is definitely faster. But by all means do your own tests; it's pretty easy to do so and satisfy yourself... -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "ntlug.org") http://cbbrowne.com/info/languages.html "It worked about as well as sticking a blender in the middle of a lime plantation and hoping they'll make margaritas out of themselves." -- Frederick J. Polsky v1.0 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
