title: Index in partitioned table
body: <p>How MySQL create index for a partition table, Example if I create 5 hash by ID  partitions:</p>
  
  <ul>
  <li>Create 1 global index for all data and 5 partitions will use this index</li>
  <li>Create 5 partitioned index with subdata in 5 partitioned tables</li>
  <li>Create 5 index with all data in 5 partitioned tables </li>
  </ul>
  
  <p>Thanks </p>