Details
-
Bug
-
Status: Open
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
None
-
DocumentNodeStoreService: RDB
Oracle 18C
Jackrabbit OAK 1.36
Description
Added over 5 million documents to Jackrabbit OAK after that performance problems started with following query. Using Oracle DB for DocumentNodeStoreService It s doing table access full scans.
select ID, MODIFIED, MODCOUNT, CMODCOUNT, HASBINARY, DELETEDONCE, VERSION, SDTYPE, SDMAXREVTIME, DATA, BDATA from NODES where ID > :1 and ID < :2 order by ID FETCH FIRST ? ROWS ONLY
Looks like Oracle DB oes not like ID column index and switches to table full scan, because ID column is not number. As a solution probably index hint need to be added and there should index name for ID column.