Re: Creating indexes takes too long

From: Hari Krishna Dara <hari_newsgroups_at_yahoo.com>
Date: 17 Mar 2003 12:57:03 -0800
Message-ID: <16dcd029.0303171257.157e03d7@posting.google.com>

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E6FE7DB.DCA4A79_at_exes
>
> CREATE TABLE test (
> f1 NUMBER,
> f2 NUMBER,
> f3 NUMBER,
> f4 NUMBER,
> f5 NUMBER);
>
> BEGIN
> FOR i IN 1..30000
> LOOP
> INSERT INTO test VALUES
> (i, i+1, i, i+2, i);
> END LOOP;
> COMMIT;
> END;
> /
>
> SET TIMING ON
>
> CREATE INDEX ix_test ON
> test (f1, f2, f3, f4, f5);
>
> Elapsed: 00:00:04.07
>
> On an IBM ThinkPad 600X with 500MHz PIII and 512MB RAM running Oracle
> 9.2.0.1.
>
> That's 4 seconds. I find your timing on SQL Server abominable too.
>
> If it is taking you minutes ... it is because you need to hire some Oracle
>
> talent to help you properly install, configure, and work with Oracle.
>
> Daniel Morgan

Hello Daniel, you are absolutely right that we need a DBA, but guess what, it is the economy :(

Thanks,
Hari Received on Mon Mar 17 2003 - 14:57:03 CST