Soft Referential Integrity - Advantages and table Maintenance Issues
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.