如果只需要索引中包含的值,而不需要读取这些行。
If the values contained in the index are all that is required, the rows are not read.
然而,如果每个不同的索引值都有许多重复的行,而所关联的表是高度群集的,那么通过索引添加的连接成本可能很低。
However, if there are many duplicate rows per distinct index value, and the associated table is highly clustered, the added costs of joining through the index can be slight.
该方法接受5个参数:行索引、列索引、单元格值、电子表格键和工作表键。
This method accepts five arguments: the row index, the column index, the cell value, the spreadsheet key, and the worksheet key.
应用推荐