title: SQL Server: Can I create a 'synthetic' relation that has no indexing or constraint checking overhead?
body: <p>What I wish to do is ensure that the foreign key relation is maintained in the database schema but for performance reasons, not enforce the constrain or incur any indexing overheads. It's purpose is purely to document the relationship. This is typically referred to as a "synthetic relation".</p>