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 <[email protected]>,
Arne Scheffer <[email protected]>,
Lukas Kreft <[email protected]>
@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.
Greetings,
Marius Timmer
explain_sortorder-v2.patch
Description: Binary data
--- Marius Timmer Zentrum für Informationsverarbeitung Westfälische Wilhelms-Universität Münster Einsteinstraße 60 [email protected]
smime.p7s
Description: S/MIME cryptographic signature
