Is there a performance penalty when joining two tables in separate schemas (However in the same database).
My physical model开发者_如何学Go has several distinct sections that fit nicely into their own schemas, however I occasionally need to join across schemas and I've been unable to find any information on if this has a negative performance impact.
No, a schema is just a namespace.
Performance might be different when tables (or their indexes) are stored on different tablespaces. One tablespace might be on a fast storage device, the other on a slow one. But that's your choice and has nothing to do with a schema.
精彩评论