partitioning column的意思
partitioning column中文翻譯:
分配柱
column───n.縱隊,列;專欄;圓柱,柱形物
fluted column───凹槽柱
column chromatography───柱層析(法),柱色譜(法);柱層析法;[分化]柱色譜法
buckling column───屈曲柱
remarks column───[計]備注欄
column heading───[計] 列標題,欄標題;[計]欄標題
in column───編隊
rectification column───[化] 精餾塔;[化工]精餾塔
chromatography column───[建] 色譜精煉柱;層析柱
For example, one cannot use identity columns or timestamps for the partitioning column, but the partitioning column has to be part of the primary key.───例如,我們無法針對分區的列使用標識列或者時間戳,而分區列需要是主鍵的組成部分。
Because there is a predicate, cust_order_number between 100000 and 580000, on the partitioning column, the optimizer is able to limit the TBSCAN to the first nine partitions.───因為有一個謂詞,cust_order_number處于100000到580000之間,在分區列上,優化器能夠限制TBSCAN到頭九個分區。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.───如果數據庫設計者已在表上創建了主分區索引,那么查詢應當與分區列結合。
The partitioning column must be in the same ordinal location in the select list of each SELECT statement in the view .───在視圖中,分區列必須位于每個SELECT語句的選擇列表中相同的序號位置。
The actual column, known as a partitioning column, is specified in the CREATE TABLE or CREATE INDEX statement.───實際列(也稱為分區列)是在CREATETABLE或CREATEINDEX語句中指定的。
The constraints should be in an enabled and trusted state for them to meet the previously mentioned conditions of the partitioning column.───約束應處于啟用和信任狀態,以使它們滿足分區列的上述條件。
To meet the conditions of the partitioned view, there should be only one partitioning constraint on the partitioning column.───若要滿足分區視圖的條件,在分區列上應只有一個分區約束。
A way of partitioning a table or index by specifying partitions to hold rows that have ranges of values from one partitioning column.───一種對表或索引進行分區的方法,指定一些分區來保存一個分區依據列中值在一定范圍內的行。
The partitioning column cannot be an identity, default or timestamp column.───分區列不能是標識、默認值或timestamp列。
If the database designer has created a Primary Partition Index on a table, queries should incorporate the partitioning column.