tag:blogger.com,1999:blog-594392348185533137.post4398320792967007102..comments2022-12-05T00:57:31.158-06:00Comments on ScrappyDog: My client doesn't allow the use of Foreign Key Constraints in SQL ServerEric Bowenhttp://www.blogger.com/profile/16365330785571984254noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-594392348185533137.post-67121524152792389282008-07-16T17:54:00.000-05:002008-07-16T17:54:00.000-05:00Many, many moons ago I worked as Oracle DBA - in O...Many, many moons ago I worked as Oracle DBA - in Oracle6 the data dictionary was redefined, and you could specify primary & foreign keys - but they weren't enforced! That came with Oracle7 onwards.<BR/><BR/>I've never seen performance degradations BECAUSE of using FKs. I did see a lot of apps who weren't aware of (properly) using them. In my experience DBA's usually knew a lot about PKs and FKs, and developers next to nothing... In a lot of apps developers just happily re-coded FK functionality in PL/SQL, go figure...<BR/><BR/>I'm not familiar with SqlServer, so is this performance degradation a MS f*ckup?Fred Wiersmahttps://www.blogger.com/profile/08146053762848300180noreply@blogger.com