Archives of the TeradataForum
Message Posted: Sat, 09 Jul 2005 @ 08:28:00 GMT
<-- Anonymously Posted: Saturday, July 09, 2005 04:03 -->
A couple of questions on RI.
How do I identify both tables bound by RI constraints?
Also, can anyone share any findings when using the 'soft-RI' feature? When does the optimiser decide not to join? Is it when PI selection is used? I'm seeing explains where a join is taking place even when columns from only one table are referenced.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|