List:General Discussion« Previous MessageNext Message »
From:Bill Koob Date:September 19 1999 11:01am
Subject:Indexes
View as plain text  
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




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