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