A probe scan is used to directly look up rows in an index or base table.
探测扫描用于直接在索引或基表中查找行。
Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
探测扫描的数目。探测扫描用于直接在索引或基表中查找行。
Since Query 1 expresses the join predicate on the books table, DB2 9.1 and 9.5 perform a table scan on authors and then use the index AUTHORIDX1 to probe into the books table.
由于查询1表达了books表中的连接谓词,所以DB 2 9.1和9.5执行一个扫描authors的表,然后使用索引authoridx 1查找books表。
应用推荐