Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 21:23:12 GMT

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

Actually, the 2746 is a warning that a join index has been marked invalid and will not be used by the optimizer. What you need to do is drop and re-create the join index to get it back in sync with the data.

Unfortunately, the message does not tell you the name of the join index; it tells you the name of the table that is included in some join index. You have to find the join index yourself.

The cause of the 2746 message (in this case) is restoring a table that is included in some join index. When you do that, the join index no longer is valid. That's why it needs to be re-loaded.

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