>index but doesn't explain the 30 minute elapsed time for your locate. In your >example, are the tables being updated constantly?

Sorry, I've been away for a while.

They were not being updated while I was doing my testing. The only updates would have been from the workstation I was using, and everyone had gone home for the day anyway.