3 ms·

No such thing. The database interface is SQL. The query optimizer is something run in the database.

• goto11 6y ago
  Yes I mean inside the database engine. The engine receives SQL and parses it and then pass the query tree to the optimizer which generate a query plan. My question is how the optimizer could have problems if the SQL is generated as opposed to hand-written? How could that make a difference?
  • mixedCase 6y ago
    As mentioned in another the comment, because SQL that is hand-written for non-trivial cases will too often be better than what an ORM generates.
    • goto11 6y ago
      This is so hand-wavy I can't really argue against it.