Thanks, but no credit to me, I was just relaying the existence of this knowledge... there are some much better SQL dabblers here than me!
Aaron On Mon, 28 Apr 2003, Jacques Beaudoin wrote: > Right on Aaron .... > > I just alter my dbmail tables and like you say: > > > Speed increases as dramatically as server load drops > > after adding these. > > > > mysql: > > > > alter table mailboxes add index (name); > > alter table mailboxes add index (owner_idnr); > > alter table mailboxes add index (is_subscribed); > > alter table messages add index (mailbox_idnr); > > alter table messages add index (seen_flag); > > alter table messages add index (unique_id); > > alter table messages add index (status); > > Thanks again Aaron > > > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
