Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating indexes takes too long

Re: Creating indexes takes too long

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Tue, 18 Mar 2003 01:49:04 GMT
Message-ID: <kWuda.121763$F1.3803@sccrnsc04>


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...

> 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 - 19:49:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US