From: Dan Nelson
Date: August 26 2004 4:20am
Subject: Re: Two indexes on same column. Crazy ?
List-Archive: http://lists.mysql.com/mysql/171578
Message-Id: <20040826042019.GB91848@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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