It's a big help if you know how to retrieve and interpret execution plans for the database you use.
When you have a solid view of the schema and data sizes you can start to be more predictive about what your code will actually do, THEN you can layer on the complexity of the ORM hell code.