ALTER TABLE core_person ADD COLUMN post_code VARCHAR(256) NOT NULL DEFAULT '';
-ALTER TABLE core_person ADD COLUMN oath_key VARCHAR(254) NOT NULL DEFAULT '';
\ No newline at end of file
+ALTER TABLE core_person ADD COLUMN oath_key VARCHAR(254) NOT NULL DEFAULT '';
+
+alter table core_person add index lookup_company_id( company_id);
+alter table core_person add index lookup_buying_head_id( buying_head_id);
\ No newline at end of file