jxiong,

What's the point of indexing a field that is 100% unique?

Surely the index would take as long to search as the table itself?