List:General Discussion« Previous MessageNext Message »
From:Mark Date:May 16 2002 12:35am
Subject:Re: Alter table
View as plain text  
----- Original Message -----
From: "Benjamin Pflugmann" <benjamin-mysql@stripped>
To: "Mark" <admin@stripped>
Cc: <mysql@stripped>
Sent: Thursday, May 16, 2002 1:24 AM
Subject: Re: Alter table


> Hi.
>
> Please start a new thread next time, instead of replying to a
> completely unrelated topic. Thank you.
>
> It sounds as if you want
>
> ALTER TABLE your_table ADD INDEX( message_id )
>
> It is probably enough to only index some part of that field and
> save a lot of space:
>
> ALTER TABLE your_table ADD INDEX( message_id(15) )


Thank you!! The new index caused the search on message_id to be about
hundred times as fast! :) Yay! :)

- Mark

Thread
Column Header/ Column Descriptionmike markovich15 May
Re: Column Header/ Column DescriptionPaul DuBois15 May
RE: Column Header/ Column Descriptionmike markovich15 May
  • Re: Column Header/ Column DescriptionMark Matthews15 May
    • Re: Column Header/ Column DescriptionKeith C. Ivey15 May
      • Re: Column Header/ Column DescriptionMark Matthews16 May
      • Alter tableMark16 May
        • Re: Alter tableBenjamin Pflugmann16 May
        • RE: Alter tableRoger Baklund16 May
      • Re: Column Header/ Column DescriptionMikeParton16 May
      • Re: Alter tableMark16 May
        • Re: Alter tableBenjamin Pflugmann16 May
      • Re: Alter tableMark16 May
  • RE: Column Header/ Column DescriptionGurhan Ozen15 May
RE: Column Header/ Column DescriptionPaul DuBois15 May
RE: Column Header/ Column Descriptionmike markovich15 May
RE: Column Header/ Column DescriptionSteve Orr16 May
  • Re: Column Header/ Column DescriptionMark Matthews16 May