Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-301

query optimizer hint: sort index or full text index

    XMLWordPrintable

Details

    • Core: Platform - Sprint 56, Core: Platform - Sprint 57, Core: Platform - Sprint 58, Core: Platform - Sprint 59
    • 3
    • Core: Platform

    Description

      Give hint to postgres query optimizer for a query using full text search, sort and limit:

      • Use the sort column index (starting a full table scan) when there are many matches so that the first 30 (or whatever limit) records are found quickly (using the full text index would take long time)
      • Use the full text index when there are a small number of matches (using the sort column index requires to do a full table scan).

      See MODINVSTOR-215 for details.

      TestRail: Results

        Attachments

          Issue Links

            is blocked by

            Bug - A problem which impairs or prevents the functions of the product. RMB-293 executeTransParamSyntaxError: IllegalStateException: Test already completed

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-350 PgUtilIT not tested

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Task - A task that needs to be done. RMB-352 PgUtil test coverage

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. RMB-356 PgUtil.java code review

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Open

            Task - A task that needs to be done. MODINVSTOR-215 use sort or search index depending on the result size

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-321 999 999 999 Records found

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                evaluk Eric Valuk
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases