how to create index in codeigniter migration code example
Example: codeigniter dbforge add index
$sql = "CREATE INDEX your_index_name ON table_name(field_name)";
$this->db->query($sql);
$sql = "CREATE INDEX your_index_name ON table_name(field_name)";
$this->db->query($sql);