DEV Community

Qing
Qing

Posted on

Creating an Index for an MOT Table

#opengauss

Standard PostgreSQL create and drop index statements are supported.

For example –

Image description

The following is a complete example of creating an index for the ORDER table in a TPC-C workload –

Image description

Image description

For MOT index limitations, see the Index subsection under the _SQL Coverage and Limitations _section.

Top comments (0)

Read next

mustafacam profile image

IOC Java

Mustafa Çam -

myfear profile image

Use local AI Models easily for Development and Experimentation

Markus -

regalman profile image

Do not use array.sort() Function Without a Compare Function in JavaScript

Saharat Paynok -

grover_sumrit profile image

Git 101 for Beginners: Learn Git Commands, Branching, and Collaboration

Sumrit Grover -