Archives of the TeradataForum
Message Posted: Wed, 18 Oct 2000 @ 11:04:18 GMT
You do not mention if you have secondary indexes and/or have collected statistics on the foreign key fields in the fact table? You might try this to give the optimizer information on both sides of the possible joins.
David W. Roth
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|