title: Which index should I use on binary datatype column mysql
body: <p>I am writing a simple tool to check duplicate files(i.e. files having same data). The mechanism is to generate hashes for each file using sha-512 algorithm and then store these hashes in MYSQL database. I store hashes in binary(64) unique not null column. Each row will have a unique binary hash and used to check file is duplicate or not.</p>
  
  <p>-- My questions are --</p>
  
  <ol>
  <li><p>Can I use indexes on binary column, my default table collation is latin1 - default collation?</p></li>
  <li><p>Which Indexing mechanism should I use Btree or Hash, for getting high performance? I need to update or add 100 of rows per seconds.</p></li>
  <li><p>What other things should I take care of to get best performance?</p></li>
  </ol>