Creating an Index for an MOT Table

Standard PostgreSQL create and drop index statements are supported.

For example –

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

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