Node DB Primary Keys - CLUSTERED vs NONCLUSTERED


Sean
 

Hi Team,
  About 2/3 of the Corda primary keys are clustered, the remaining 1/3 nonclustered. For example, two of the major tables, vault_states and node_transactions have nonclustered pkeys.
  Of course, our DBA can make necessary optimization index changes on our node DBs. I was just wondering/curious about Corda's rationale behind the indexing decision if any.

  Thanks.

\Sean

Join corda-dev@groups.io to automatically receive all group messages.