List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 26 2004 4:20am
Subject:Re: Two indexes on same column. Crazy ?
View as plain text  
In the last episode (Aug 26), Alistair Gusmao said:
> I inherited a database with all MyIsam tables. In one of the tables,
> there was two indexes on the same column. Everything about the two
> indexes is the same (except the index name of course!). I think this
> is crazy ? What is your opinion ? Should I remove one of them ?

If they're identical, then yes, you're just wasting space and CPU.


-- 
	Dan Nelson
	dnelson@stripped
Thread
Two indexes on same column. Crazy ?Alistair Gusmao26 Aug
  • Re: Two indexes on same column. Crazy ?Dan Nelson26 Aug