infrastructurebuilder / ibdata-api-root

IBData api and associated components
1 stars 0 forks source link

Create multi-part indexes #4

Open mykelalvis opened 4 years ago

mykelalvis commented 4 years ago

Depends on #3.

Both PK and regular indexing should be able to be multi-part

Markdown from original text follows:

If the "doc" section of a field contains the text #INDEX=, the string after the = up to the next whitespace will be the index name.

If more than one field has the same #INDEX= value, then that will be a composite index. Composite order will be based on order of appearance in the schema (specifically based on field.pos())

AND

As with multi-part keys, if more than one key has #PRIMARY #INDEX=xxxx specified, then the primary key will be composite based on field position.