in reply to Re^5: Key to use for files in db!
in thread Key to use for files in db!
Why do you think that the fastest means the best? :>)))
But I am afraid of your problem is not fully resolvable without some experiments.
Ad #3 - the md5 hash is (re)calculated when the _index_ built or modified, so the special column is not necessary. And, when the query runs, only md5 of queried string is calculated.