Changes between Initial Version and Version 1 of Ticket #30207, comment 7


Ignore:
Timestamp:
Jun 9, 2019, 4:02:36 AM (5 years ago)
Author:
M. Javidan Darugar

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #30207, comment 7

    initial v1  
    11Well this is a bit surprising for me as well that many developers don't know about this, because it is a very basic fact in database core, maybe because most developers focused on code base rather than raw queries.
     2
     3But there are good reference to read more about these concepts and facts about databases:
     4- https://www.scarydba.com/2016/10/24/sub-query-not-hurt-performance/
     5
     6But this one gives developers a great insight about database (I read edition 2014 but I believe new edition will be published soon):
     7Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
     8
     9
    210
    311Replying to [comment:2 Simon Charette]:
Back to Top