On Sat, Feb 19, 2011 at 8:18 AM, James Hogarth <james.hogarth at gmail.com> wrote: > So getting back to the original post and discussion.... > > We could have the username separate from the email side of things and > do LDAP lookup on that... > > There would still be consistent logins throughout but would be easier > for email changes for notification of PMs etc on forums etc. Bingo. So the index is......... What? Its own value, typically an incrementing number, just like it is for most sane databases. Tying indexes to integral components of a database is one of the more hateful errors in large project integration that I've had to deal with several times lately.