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 (Inactive)
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 4 weeks, 6 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