When you add many keys to a database table, it can decrease performance. However, you can make the keys members of predefined key groups and enable them only when they will be used. This improves performance.

To enable or disable a key group

  1. In the development environment, on the File menu, choose Database, and then choose Information to open the Database Information window.

  2. In the Database Information window, choose the Tables button.

  3. In the Database Information (Tables) window, choose the Key Groups button. The Database Key Groups window opens.

  4. In the Database Key Groups window, select the key group you want to enable or disable, and then choose the Enable or Disable button.

  5. In the dialog box, choose the Yes button to enable or disable the key group.

See Also