CODE EXAMPLE FOR SQL

codeigniter dbforge add index

$sql = "CREATE INDEX your_index_name ON table_name(field_name)";
$this->db->query($sql);