Hello everyone,

For creating indexes on more than one column, it is useful to know the sort
order of each sort key. So now, if you run EXPLAIN in VERBOSE mode, you get
the sort order information in the order the sort keys are displayed - Lukas

 - This patch is meant for discussion
 - It’s against the master branch
 - The patch compiles successfully and one test (inherit) is affected
 - There are no platform-specific items in this patch
 - The patch, as described, enhances EXPLAIN VERBOSE. For an example, see
   the regression test
 - There is no TODO item referring to this patch

      @patchname: explain_sortorder v2
        @version: 2.01
         @author: Marius Timmer <mtimm...@uni-muenster.de>,
                  Arne Scheffer <arne.schef...@uni-muenster.de>,
                  Lukas Kreft <lukaskr...@uni-muenster.de>
    @description: Display sort order options in VERBOSE mode of EXPLAIN

 - The situation

   Currently I am able to run a EXPLAIN-Statement (verbose) for getting more
   Information about a Query. But it is not enough to check in which order the
   results will be sorted, what could be interesting to modify some Statements
   so they can become more performant.

 - What this patch does

   This patch will add one more information to the result of an EXPLAIN-
   Statement in verbose-mode. You will find the new property "Sort order"
   which tells you the order of the used keys while sorting.
   You can use it in all available Formats.


Marius Timmer

Attachment: explain_sortorder-v2.patch
Description: Binary data

Marius Timmer
Zentrum für Informationsverarbeitung
Westfälische Wilhelms-Universität Münster
Einsteinstraße 60


Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to