From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

You can recompile one or more tables. Recompilation causes each procedure and trigger that uses the target table to be recompiled the next time it runs.

The queries used by procedures and triggers are optimized only once, when they are compiled. As you add indexes or make other changes to your database that affect its statistics, your compiled procedures and triggers may lose efficiency. By recompiling the procedures and triggers that act on a table, you can optimize the queries for maximum efficiency.

Platform Availability

To Recompile One or More Tables

  1. Initiate a Recompile action against one or more tables. For more information see Initiating an object operation.
    The Recompile Tables dialog opens.
  2. Click Execute. For information on the scheduling option, see Scheduling.