Archives of the TeradataForum

Message Posted: Sun, 24 Sep 2001 @ 21:15:49 GMT

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

Karen,

The explain looks pretty reasonable to me. Do you have any idea if the query was doing real work, i.e. consuming CPU cycles and IO? Check DBC.AMPUSAGE. I'm wondering if your query is being blocked. Is it possible that you have a Utility lock on that table or database left over from an archive or restore? Check SHOWLOCKS. If the query is doing work, is the query skewed? I doubt it if you have a unique primary index on terr_id.

Hope this helps.

Regards,

Thomas F. Stanek
TFS Consulting

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