> At 10:36 PM 01-01-2003 +0800, you wrote:

> Indexes are 'unique' fields in a table - and cannot in any way be 
duplicated
> (otherwise point less having an index) - thus to increase the efficiency 
it
> is often better to have an auto-increment as an index in a table.

<sound from gameshow - boh boom> 

indexes dont have to be unique. :D

a primary key is, however, a(n?) unique index.

as for having an auto-increment as an index, I would suggest that if you 
need to bother with an auto-increment at all (ie you cannot extract any 
useful form of uniqueness from the data, or the unique data is very large) 
that perhaps the auto increment field should be the primary key. 

:)




