Soft Referential Integrity - Advantages and table Maintenance Issues

Database
Enthusiast

Soft Referential Integrity - Advantages and table Maintenance Issues

Hi Everyone,

 

I need some advice based on real life expierence concerning the advantages of using Soft RI and resulting table maintenance issues. I have had some expieence with soft RI and found table maintenance a real pain when needing to drop and re-create tables and have read some posts concerning restore issues as well. The only advantages I have found using soft RI is documentation of foriegn keys and some join elimination in one  very specific situation. I would appreciate input from someone with soft RI expieremce concerning   advantages and issues of using soft RI and whether the advantages are worth dealing with the  issues.

 

Thanks