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

    • Template:
    • Sprint:
      Core: Platform - Sprint 56, Core: Platform - Sprint 57, Core: Platform - Sprint 58, Core: Platform - Sprint 59
    • Story Points:
      3
    • Development Team:
      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

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases