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

karanjain2527 profile image

Cyber Attack Chronicles: Types and Real-Life Examples Demystified

KARAN JAIN -

mmvergara profile image

Elegant Error Handling and End to End typesafety with Hono RPC

mmvergara -

colinfay profile image

Introducing Rlinguo, a native mobile app that runs R

Colin Fay -

jmouradeveloper profile image

O mistério do objeto de Ruby escondido Singleton Class

João -