Archives of the TeradataForum
Message Posted: Fri, 16 Jan 2004 @ 23:08:12 GMT
Can someone help me out in optimizing a select query which inner joins two table one big and another small? Precise information is below:
Table x: 23296802 Table y: 173
Current Retrieval Time : 10 Mins
Table x has surrogate key and the other composite candidate key is a,b,c,d.
Table y has primary index on a,b,e,f,g,h
I am joining on a and b column. Now since I don't have an option of using the surrogate key on which the data distribution happens.
I can't even create a secondary index on it due to space constraint.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|