[wp-trac] [WordPress Trac] #36343: Taxonomy query matching specified term or NOT EXISTS does not return expected result

[WordPress Trac]

#36343: Taxonomy query matching specified term or NOT EXISTS does not return
expected result
------------------------------------------------+--------------------------
 Reporter:  crstauf                             |       Owner:
     Type:  defect (bug)                        |      Status:  new
 Priority:  normal                              |   Milestone:  Future
Component:  Query                               |  Release
 Severity:  normal                              |     Version:  4.1
 Keywords:  has-patch has-unit-tests 4.6-early  |  Resolution:
                                                |     Focuses:
------------------------------------------------+--------------------------

Comment (by pento):

 Yes, `INNER JOIN` can be faster in some cases, if the optimiser thinks
 that reading from the second table first is a better query plan.

 That said, the performance difference will either be negligible (in the
 case that the columns being joined on are properly indexed) or irrelevant
 (in the case that they're not properly indexed, the query might be
 optimised from "really slow" to "kinda slow").

 I don't think the performance gain is worth adding the code complexity.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36343#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform