如果应用程序频繁地访问没有适当索引的小表,数据库每次都会把它们装载进内存并扫描它们。
If your application frequently accesses smaller tables without proper indexes, the database will load them into memory each time and scan them.
账单表出了什么问题,使得优化程序认为需要顺序扫描整个表?
What is wrong with the bills table that the optimizer thinks it should sequentially scan the entire table?
MON_GET_INDEX 表函数和 db2pd 实用程序提供相同的索引度量指标(扫描索引和仅扫描索引的数量)。
The MON_GET_INDEX table function and db2pd utility provide the same index metrics (number of index scans and index only scans).
应用推荐