by andy » Wed, 14 Aug 2002 15:02:53
My assumption is that the 'relational engine' inside of sqlserver uses the
DRI relationships in the catalog in the database to create more efficient
execution plans.
I need proof I am right in this assumption, or proof I was wrong and why.
Thanks
by CR » Wed, 14 Aug 2002 16:51:53
Quote:> Am looking for '*' technical documentation explaining if and why
you
> Create DRI relationships in a microsoft sql server for any reason other
than
> declared referrential integrity????
> My assumption is that the 'relational engine' inside of sqlserver uses the
> DRI relationships in the catalog in the database to create more efficient
> execution plans.
> I need proof I am right in this assumption, or proof I was wrong and why.
> Thanks
1. technical reasons for splitting data-model into schemes
Are there any technical reason - besides better organization for
developers, dba's - for splitting a big data-model into schemas?
The only technical consequence I know is the default tablespace and
temporary tablespace.
Does somebody know any splitting criterias? (e.g. group by business
area, ...)
TIA
Michael
3. Doubt with relationship to the relationship?
5. Relationships using relationships?
6. Sybase 10 (Netware) to Sybase 11 (NT)
7. Indeterminate relationships in Relationships Window
8. PLEASE PLEASE HELP!!! SQL NESTED TRANSACTIONS
9. MA-Framingham-108527--UNIX-ORA
10. IL-CHICAGO-88345--SYBASE-Infor
11. MA-Framington-108527--UNIX-ORA
12. OH-CINCINNATI-106557--Visual Basic-Technical Support-ORACLE-Help Desk Support-TECHNICAL SUPPORT