cgtt

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

熱門查詢