Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-60100

Prevent Oracle from doing a full table scan due to "IS NULL" check of publishDate and expirationDate within the query of AssetEntryFinder

    Details

      Description

      In Oracle, the performance of the query of AssetEntryFinder can be improved if we prevent full table scans due to the "IS NULL" check of publishDate and expirationDate.

      For this, we need a new index on the table that includes the entryId plus all columns that can have a null value, because in this case Oracle will still index the rows, even if the nullable columns are null. An example in detail is demonstrated here: http://stackoverflow.com/questions/1230786/when-does-oracle-index-null-column-values/1230944#1230944

      Since the issue is Oracle-specific, and we don't support Oracle in 7.0 CE anymore, this fix is intended for ee-7.0.x and ee-6.2.x only.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                lu.liu Lu Liu
                Reporter:
                gergely.mathe Gergely Mathe
                Participants of an Issue:
                Recent user:
                Csaba Turcsan
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 46 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP16
                  7.0.3 CE GA4
                  7.0.0 DXP SP4
                  7.0.X EE
                  Master