total predicate

基本解釋

For example, SELECT * FROM orders WHERE Total > 2000 would not only lock the rows that match the predicate condition, but also all rows in the table.
例如， SELECT * FROM orders WHERE Total > 2000 鎖定了所有表格中的行而不僅僅是那些和判定條件匹配的行。
Cardinality -- The total number of qualifying rows estimated by the optimizer after filtering operations, such as predicate application or aggregation, are applied.
基數(shù)（Cardinality） —— 應(yīng)用篩選操作（比如使用斷言應(yīng)用程序或聚合）之后，優(yōu)化器估計符合條件的總行數(shù)。