Modifying Access Paths › Understanding Access Path Auxiliaries › For SQL Access Paths with *IMMED Maintenance

For SQL Access Paths with *IMMED Maintenance

When an access path that is implemented in SQL is created with *IMMED index maintenance, CA 2E also creates an SQL index as an access path auxiliary. You can suppress generation of the SQL index and also retain *IMMED maintenance capability.

For more information on SQL, see the "SQL Implementation" appendix in the Administration Guide.

For DDL Access Paths with *IMMED Maintenance

When an access path that is implemented in DDL is created with *IMMED index maintenance, CA 2E creates only an SQL index as an access path auxiliary.

For more information on SQL, see the "SQL/DDL Implementation" appendix in the Administration Guide.