#DateForumTypeThreadPost
704 Jul 2016 @ 09:58 PDTDatabaseTopicTACTICAL QUERIES ON WINDOWS FUNCTIONDear ATRs, I have a "simple" view V made by a "driving" table T (250 Mln rows) and a "left table" L (220 Mln rows) with a window fu...
608 Mar 2016 @ 12:00 PSTGeneralReplyNeed help in pointing out the exact issue leading to high CPU usage to improve query performance.Hi Soumik, the step in your explain is long because it do a sort on 2 billion rows ! Sorting is a very cost computing operation ! Can you show me the overall query and the tables involved ? You ...
522 Apr 2015 @ 12:33 PDTConnectivityReplyGET METADATA FROM JDBC DRIVER (Query NOT performant)Thank you very much for your quick reply. Can you tell me when the JDBC RFC 161165 will be ready ? regards,    
421 Apr 2015 @ 11:13 PDTConnectivityReplyGET METADATA FROM JDBC DRIVER (Query NOT performant)Hi all, I forget to report the whole query: SELECT CAST (NULL AS VARCHAR(30)) AS TABLE_CAT,     t.DatabaseName AS TABLE_SCHEM,     t.TableName AS TABLE_NAME, &...
321 Apr 2015 @ 11:10 PDTConnectivityTopicGET METADATA FROM JDBC DRIVER (Query NOT performant)Hi All, one of my customer sent me a query generate by JDBC driver 15.00.00.20 to get some metadata. the execution of the query is not performant. I analyse the query and find that the where condi...
209 Jan 2014 @ 04:27 PSTDatabaseReplyActive running Queries?Hi Dieter, I try to run the query above SELECT * FROM TABLE (MonitorSession(1,'*',0)) AS dt on my TD 14.10 with dbc user. The result is  *** Failure 7507 The UDF/XSP/UDM SYSLIB.Mon...
125 Nov 2013 @ 06:13 PSTGeneralReplyMVC ToolHi Omar,                     you can try to find a tool written by a teradata colleague. The name of ...