MOT Usage

Using MOT tables is quite simple and is described in the few short sections below.

openGauss enables an application to use of MOT tables and standard disk-based tables. You can use MOT tables for your most active, high-contention and throughput-sensitive application tables or you can use MOT tables for all your application's tables.

The following commands describe how to create MOT tables and how to convert existing disk-based tables into MOT tables in order to accelerate an application's database-related performance. MOT is especially beneficial when applied to tables that have proven to be bottlenecks.

Workflow Overview

The following is a simple overview of the tasks related to working with MOT tables –

• Granting User Permissions

• Creating/Deleting an MOT

• Creating an Index for an MOT Table

• This section also describes how to perform various additional MOT-related tasks, as well as MOT SQL Coverage and Limitations –

• Granting User Permissions

• Creating/Deleting an MOT

• Creating an Index for an MOT

• Converting a Disk Table into an MOT

• Query Native Compilation

• Retrying an Aborted Transaction

• MOT External Support Tools

• MOT SQL Coverage and Limitations