- 

ALTER TABLE `suggestions`

    ADD KEY `status` (`STATUS`),

    ADD KEY `biblionumber` (`biblionumber`),

    ADD KEY `branchcode` (`branchcode`);