Archives of the TeradataForum

Message Posted: Tue, 25 Jul 2006 @ 11:48:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You should drop the Join index rebuild each time you load/delete from the tables. Also before you do that, you will need to collect stat on both of the tables that you join on. You will need to collect stat on the indices in this case col1 after you are done creating your join index and over all do an explain of your query and make sure your newly created JI is being used properly. Hope this helps.

Mohommod Khan
Bull Services

	<Prev	Next>		<<First	<Prev	Next>	Last>>