cgtt
美
英 
- 網絡臨時表;全局臨時表(Created Global Temporary Table);臨時表建立
例句
If you do not, the script will be unable to define the CGTTs used by the delta table functions.
如果不這樣做,腳本就無法定義差值表函數要使用的CGTT。
First, CGTT behaves more like a regular table for SQL programmers, but with the potential of a performance advantage.
首先,CGTT的行為對SQL程序員而言更像是一個普通表,但它具有提升性能的潛力。
Because there is no locking requirement (all data is local), CGTT performs better than regular tables.
由于不需要鎖定(所有數據都是本地的),因此CGTT的性能要比普通表更好。
Class enrollment, where each student has all of the course schedule selections, each student having his own bucket in the CGTT.
班級入學,每個學生都有所有的課程安排選擇,每個學生都將自己的選擇放在CGTT中。
Create a table function that wraps the underlying monitoring table function and takes deltas against the baseline data stored in the CGTT.
創建一個表函數,它包裝底層的監控表函數,產生相對于CGTT中存儲的基線數據的差值。
Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).
使用為基線數據的每會話存儲創建的全局臨時表(CGTT)(對于每個表函數,使用一個CGTT)。
CGTTs do not support unique constraints or primary keys, but you can create a unique index.
CGTT不支持唯一的約束或主鍵,但您可以創建唯一的索引。
CGTT tables can be defined up front, and users can use them much like regular tables.
可以提前定義CGTT表,并且用戶可以像普通表一樣使用它。
CGTTs can also be used in the body of the trigger.
CGTT也可以在觸發器的主體中使用。
The procedure simply selects from the monitoring table function and inserts the data returned into the CGTT in order to take a baseline.
這個過程對監控表函數執行選擇并把返回的數據插入CGTT中以取得基線。
To adapt the method to support global reset, simply change the table creation statements to create regular tables rather than CGTTs.
要想調整此方法以支持全局重置,只需修改表創建語句,讓它們創建常規表而不是CGTT。
You will convert this DGTT to a CGTT in a later listing.
您將在稍后的清單中將這個DGTT轉換為CGTT。
Unlike DGTTs, CGTTs are created in a session and persist after the session is terminated.
與DGTT不同,CGTT在會話中創建并且在會話終止后仍然將持久保存。
Listing 2 defines a CGTT for storing the baseline monitoring data for tables.
清單2定義用于存儲表的基線監控數據的CGTT。
Once they commit their selections, they are moved from the CGTT to the real tables.
提交選擇之后,它們才從CGTT移動到實際表中。
Because CGTTs are persistent, they can be created and shared for all sessions during system setup.
由于CGTT是持久化的,因此可以在系統設置時創建并共享它們。
CGTT essentially moves the table setup process outside the session.
從本質上說,CGTT將表設置流程移到了會話外部。
Convert a declared global temporary table (DGTT) to a created global temporary table (CGTT)
將已聲明的全局臨時表(DGTT)轉換為已創建的全局臨時表(CGTT)