然后针对事实表扫描的每一行,外键也被散列并探测到位向量中,从而判断当前的事实表行是否被过滤掉了。
Then for each row from the fact table scan, the foreign key is also hashed and probed into the bit vector to determine whether the current fact table row is filtered out.
Time维度表中满足过滤条件的 time_id连接键被散列以创建一个位向量,用于过滤以上跳跃式扫描的Orders 表行。
The time_id join keys that meet the filter requirements on the Time dimension table are hashed to create a bit vector that filters rows of the Orders table from the skip scan above.
实际上,在INSERT期间惟一保持的行级锁是next - key锁,这个锁用于使INSERT不会添加键到可重复的读扫描器。
In fact, the only row-level locking that remains during INSERT is the next-key locks that are required to protect an INSERT from adding keys to repeatable read scanners.
这些nextkey锁只有在keyINSERT发现带有RepeatableRead (RR)隔离级别的扫描器在索引中的next -higher键上有一个行锁时才能获得。
These next key locks are only obtained when the key INSERT finds that a scanner with a Repeatable Read (RR) isolation level has a row lock on the next-higher key in the index.
最小的表首先被扫描,然后哈希表被填入相匹配的每个键的行指针。
The smallest table is scanned first, and the hash table is populated with Pointers to the rows that match each key.
设计中采用行扫描法识别键的闭合,并且在按键的选用和信号的传输上都有其独特之处。
The design identify shutting of key using row scanning. It is peculiar in a-side of keys selection and signal transmission.
设计中采用行扫描法识别键的闭合,并且在按键的选用和信号的传输上都有其独特之处。
The design identify shutting of key using row scanning. It is peculiar in a-side of keys selection and signal transmission.
应用推荐