Hi,
There is an idea that using relationship is not suitable in big Database (or Application).
I had checked some big Application : SharePoint Portal(2003 & 2007),
Biztalk Server and see that Microsoft dont use (even one) relatopnships in database.
Everybody, comments plz!
MA.
yes that's a behaviour that MS system tables have...i can comment on sql server system DB , rest of its product i guess must follow the same pattern....see relations (-explicit implementation) are basically constraints (or shud i say we put say a foreign key to enforce a relationship..and ask DB engine to check it (relationship) for us while we do insert/update)..so if ur sure that u wont enter wrong values in the related tables, u can save the effort of db engine testing it for u....the system SP and dll which update system views/tables(in 2000 sql server) take care that all tables data is kept in sync C of ACID properties .....