Archives of the TeradataForum
Message Posted: Sun, 24 Sep 2001 @ 21:15:49 GMT
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.
Thomas F. Stanek
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|