#DateForumTypeThreadPost
411 Mar 2015 @ 07:46 PDTDatabaseTopicPerformance issueHello     I got a performance issue to be more accurate with IO skew whenever I ran the following query it hits the max so I do abort the query, below is the query and its explain: &...
324 Feb 2015 @ 12:15 PSTDatabaseTopicTeradata error 2513 A data row is too longWhile running this query it gives the above error:   SELECT  MAX(AMPCPUTime) MAX_CPU ,MIN(AMPCPUTime) MIN_CPU ,MIN(TotalIOCount) MIN_IO ,MAX(TotalIOCount) MAX_IO ...
209 Feb 2015 @ 06:29 PSTDatabaseReplySelecting with WHERE clause leads to all-row scan .Thanks Dieter for reply,  Is it possible defining variable to get dates from a table so it wont do an all-row scan ?  Using _Date_ST_TM ,_Date_EN_TM so the optimizer changes the plan a...
108 Feb 2015 @ 06:43 PSTDatabaseTopicSelecting with WHERE clause leads to all-row scan .Hello,   I got an issue while selecting a from table with huge data and using the following WHERE clause : WHERE ( (EXTRACT ( MONTH  FROM ( VDB.AGG_NW_ACTIVITY_SUBS_DAILY.Call_Start_Da...