ALTER TABLE ProjectDirectory ADD INDEX plookup (project_id,person_id, ispm, role);
-ALTER TABLE ProjectDirectory ENGINE=InnoDB;
\ No newline at end of file
+ALTER TABLE ProjectDirectory ADD INDEX lookup_company_id (company_id);
+ALTER TABLE ProjectDirectory ADD INDEX lookup_person_id (person_id);
+
+
+
\ No newline at end of file