Re: Many indexes on a large table

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 30 May 2002 12:40:16 +0100 (BST)
Message-ID: <8ll*Opypp@news.chiark.greenend.org.uk>

Walter Campino <Walter_no_spam_Campino_at_iona.com> wrote:
>
>Questions:
>
>1) Can I somehow build these in parallel (this is a 12 CPU machine, and we
>can use them all)
>2) Any other suggestions

I usually do this sort of thing with a shell script.

For example:

---

#! /bin/ksh

(sqlplus scott/tiger << EOF
CREATE INDEX emp_ak1 ON emp(empno,ename); EOF
) &

(sqlplus scott/tiger << EOF
CREATE INDEX emp_ak2 ON emp(job,mgr);
EOF
) &

.
.
.

wait

---

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/

Received on Thu May 30 2002 - 06:40:16 CDT