unindexed

unindexed

1. The VALUE column in both tables is unindexed.

两表中的VALUE字段都未被索引。

2. they are evaluated first and behave like unindexed tables cached in memory for the remainder of the query.

他们会首先被执行，就就像是在查询中缓存的没有索引的表结果。

3. Therefore, bulk importing data in parallel into an unindexed table is usually performed with TABLOCK.

因此,通常使用TABLOCK以并行方式将数据大容量导入无索引的表中。

4. The simplest scenario for importing data in parallel is loading data into an unindexed table a.

最简单的数据并行导入方案是将数据加载到无索引的表中。