Example 1

    The following example issues commands to do the following:

    1. Display optimizer statistics for the EMPLOYEES and JOB_HISTORY
       tables and their indexes

    2. Delete the entries for the column group (EMPLOYEE_ID, JOB_
       CODE, JOB_START, JOB_END, DEPARTMENT_CODE, SUPERVISOR_ID) in
       JOB_HISTORY

    $ RMU/SHOW OPTIMIZER_STATISTICS MF_PERSONNEL.RDB -
    _$ /TABLES=(EMPLOYEES, JOB_HISTORY)/STATISTICS=(WORKLOAD)
    -----------------------------------------------------------------------

    Optimizer Statistics for table : EMPLOYEES

      Workload Column group  :      EMPLOYEE_ID
      Duplicity factor       : 1.0000000
      Null factor            : 0.0000000
      First created time     :  3-JUL-1996 10:37:36.43
      Last collected time    :  3-JUL-1996 10:46:10.73

      Workload Column group  : LAST_NAME,    FIRST_NAME,    MIDDLE_INITIAL,
    ADDRESS_DATA_1, ADDRESS_DATA_2, CITY,   STATE,  POSTAL_CODE,    SEX,
    BIRTHDAY,       STATUS_CODE
      Duplicity factor       : 1.5625000
      Null factor            : 0.3600000
      First created time     :  3-JUL-1996 10:37:36.43
      Last collected time    :  3-JUL-1996 10:46:10.74

    ----------------------------------------------------------------------

    Optimizer Statistics for table : JOB_HISTORY

      Workload Column group  :      EMPLOYEE_ID
      Duplicity factor       : 2.7400000
      Null factor            : 0.0000000
      First created time     :  3-JUL-1996 10:37:36.43
      Last collected time    :  3-JUL-1996 10:54:09.62

      Workload Column group  : EMPLOYEE_ID,    JOB_CODE,       JOB_START,
    JOB_END,        DEPARTMENT_CODE,        SUPERVISOR_ID
      Duplicity factor       : 1.5930233
      Null factor            : 0.3649635
      First created time     :  3-JUL-1996 10:57:47.65
      Last collected time    :  3-JUL-1996 10:57:47.65
    $ !
    $ ! Delete one of the entries for JOB_HISTORY
    $ !
    $ RMU/DELETE OPTIMIZER_STATISTICS MF_PERSONNEL.RDB/TABLE=(JOB_HISTORY) -
    _$ /COLUMN_GROUP=(EMPLOYEE_ID,JOB_CODE,JOB_START,JOB_END, -
    _$ DEPARTMENT_CODE,SUPERVISOR_ID)/LOG
    Changing RDB$SYSTEM area to READ_WRITE.
    Workload column group deleted for JOB_HISTORY :         EMPLOYEE_ID,
    JOB_CODE,       JOB_START,      JOB_END,        DEPARTMENT_CODE,
    SUPERVISOR_ID