Hi Woonsan,

IIRC this table contains one entry per cluster node, which usually means there are just a couple of entries. An index is therefore not necessary.

Regards
 Marcel

On 05.03.18 15:48, Woonsan Ko wrote:
Hi,

I notice that LOCAL_REVISIONS table [1] is created without a unique
index even if the JOURNAL_ID seems to be used as a primary key in
org.apache.jackrabbit.core.journal.DatabaseJournal.
Is there any reason behind?

Thanks in advance,

Woonsan

[1] 
https://github.com/apache/jackrabbit/blob/trunk/jackrabbit-core/src/main/resources/org/apache/jackrabbit/core/journal/mysql.ddl

Reply via email to