List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 19 1999 12:57pm
Subject:Re: Indexes
View as plain text  
At 6:01 AM -0500 9/19/99, Bill Koob wrote:
>Just curious I created an index using ALTER
>on a single 10 character field - it took
>6 1/2 hours on a 800Meg table with 10+ million
>records. 100 Pentium.  All seems to work
>very well (just very slow).
>
>Qestion: Would it have saved a significant
>amount of time had I created the index at
>the time I created the table and before
>loading the data?
>
>Thanks for any response,
>bill koob

No, normally creating the index in one shot is much
faster than modifying the index for each INSERT
operation.

--
Paul DuBois, paul@stripped
Thread
Linux helpScott Mackie15 Sep
  • Re: Linux helpThimble Smith15 Sep
  • select problem on 3.22.21 killing serverjim kraai15 Sep
    • select problem on 3.22.21 killing serverMichael Widenius18 Sep
  • Re: select problem on 3.22.21 killing serverjim kraai18 Sep
    • Re: select problem on 3.22.21 killing serverMichael Widenius19 Sep
      • IndexesBill Koob19 Sep
        • Re: IndexesPaul DuBois19 Sep
        • Re: IndexesBob Kline19 Sep
          • load data infile and indexes [was Re: Indexes]James Manning20 Sep
            • load data infile and indexes [was Re: Indexes]Michael Widenius20 Sep
        • IndexesMichael Widenius19 Sep