Template: PDMIndexQueryFormat

Formatting template used by Template:PDMIndexQuery to format the individual tables for each index on table pages.

{{AnchorDiv|{{{anchor}}}}}
===Index {{{indexName}}}===
{{#switch:{{lc:{{{indexPresentInPartitioned}}}}}
|n
|no=This index is present only in nonpartitioned databases.
|y
|yes
|#default=}}
{{{!}}
! '''Field'''
! '''Sort'''
! '''Comment'''
{{#if:{{{indexKey|}}}|
{{!}}-
{{!}} {{{indexKey}}}
{{!}} {{{sort}}}|
{{!}}-
{{!}} {{{indexKey1}}}
{{!}} {{{sort1}}}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned1}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey2|}}}|
{{!}}-
{{!}} {{{indexKey2}}}
{{!}} {{{sort2}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned2}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey3|}}}|
{{!}}-
{{!}}{{{indexKey3}}}
{{!}} {{{sort3}}}
{{!}}{{#switch:{{lc:{{{keyPresentInNonpartitioned3}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey4|}}}|
{{!}}-
{{!}} {{{indexKey4}}}
{{!}} {{{sort4}}}
{{!}}{{#switch:{{lc:{{{keyPresentInNonpartitioned4}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey5|}}}|
{{!}}-
{{!}} {{{indexKey5}}}
{{!}} {{{sort5}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned5}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey6|}}}|
{{!}}-
{{!}}{{{indexKey6}}}
{{!}} {{{sort6}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned6}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey7|}}}|
{{!}}-
{{!}}{{{indexKey7}}}
{{!}} {{{sort7}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned7}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey8|}}}|
{{!}}-
{{!}}{{{indexKey8}}}
{{!}} {{{sort8}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned8}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey9|}}}|
{{!}}-
{{!}}{{{indexKey9}}}
{{!}} {{{sort9}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned9}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}
{{#if:{{{indexKey10|}}}|
{{!}}-
{{!}}{{{indexKey10}}}
{{!}} {{{sort10}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned10}}}}}
|n
|no={{#switch:{{#sub:{{#explode:{{{page}}}|/|2}}|3}}
|PDMOra
|PDMMS
|PDM=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|LibraryGIM='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.
|#default=}}
|y
|yes
|#default=}}|}}|}}|}}|}}|}}|}}|}}|}}|}}
{{!}}}

Index {{{indexName}}}

Field	Sort	Comment
{{{indexKey1}}}	{{{sort1}}}