Archives of the TeradataForum
Message Posted: Tue, 14 Aug 2001 @ 12:06:06 GMT
Thank you for the response. You made a great point about Unique vs. Non-Unique primary Indexes. I didn't even think about that.
Assuming all tables have a Unique Primary Index: Instead of performing a full-table scan of all tables involved, I was thinking that the optimizer could take the intersection of all tables after each table has been filtered via the user's 'where' conditions (like a large bit- map intersection.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|