How can I view index usage in DB2?

To view the usage of indexes in DB2, you can use the following method: 1. Use the EXPLAIN tool: Using the EXPLAIN tool can provide you with the query plan, which includes information on the usage of indexes. You can use the following command to get the query plan:

  EXPLAIN PLAN FOR [查询语句];

You can then use the following statement to view the query plan:

  SELECT * FROM TABLE(EXPLAIN(NULL, NULL, NULL, -1));

You can view the usage of indexes within the query plan. Using the SYSIBM.SYSINDEXES table, you can obtain statistical information about indexes, such as the number of times they have been used and scanned. Use the following statement to query:

  SELECT * FROM SYSIBM.SYSINDEXES WHERE TBNAME = '[表名]';

Replace [table name] with the specific table name. Use tablespace statistics: You can query tablespace statistics to get information on index usage. You can use the following statement to query tablespace statistics.

  SELECT * FROM SYSIBMADM.SNAPDB;

In the query results, you can view information such as the number of scans and updates performed on an index. These methods can help you monitor the usage of indexes in DB2. Please choose one method as needed to check the usage of indexes.