Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating indexes takes too long
So what they are really telling you is that your time is not worth much.
Live with poor performance because we can't afford to have you work more
efficiently by hiring someone or getting some consulting time.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Hari Krishna Dara" <hari_newsgroups_at_yahoo.com> wrote in message news:16dcd029.0303171257.157e03d7_at_posting.google.com...Received on Mon Mar 17 2003 - 19:49:04 CST
> 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