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