Tune Table

This option should be used on tables with large amounts of data, such as the Billing_Tx_Charge_Detail, Billing_Tx_History tables, or Batch_Clm_Svc_Detail.

RADplus Utilities > Database Management > Tune Table

• When this form is submitted, selected tables will receive a new or updated entry in the SYSTEM.RADplus_table_manager table, with the 'scheduled' property set to 1.
• Then a background process will launch in each application that has tables selected. As each table is tuned, its 'scheduled' property is reset to 0.
• If this form is submitted multiple times during the day, multiple background jobs will launch and be queued up to run successively. Subsequent submissions are not 'added' to an existing background job.
• If the background process is interrupted by system shutdown, the process will restart during Cache startup and process all tables which were still 'scheduled' at the time of system shutdown. 
• SQL Views are not available for tuning selection.
• You can run Tune Table while users are in the system but they CANNOT be accessing the tables that are being tuned. There are no performance issues that have been reported to date for this.
• You should run Tune Table whenever a table used in a report is updated/changed, such as may occur when myAvatar updates are loaded.

1. Click Select Tables for Tune Table. A list of tables that are available for tuning appears.
2. Select the tables for which you would like to improve performance.
3. Click OK.
4. Click Submit.

The next time the chosen tables are accessed by myAvatar , a process to tune the table will be started.

You may notice a slow down the first time you access one of the tables during the tuning process. All subsequent times, accessing the chosen tables will be faster.