#DateForumTypeThreadPost
713 May 2016 @ 10:48 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';Really good script Nelluri. Will surely come in handy.
627 Jun 2013 @ 01:33 PDTConnectivityTopicHow to Get the Session info (example: session number/id) when using Teradata .NET Provider.Hi All, After creating a connection using the Teradata .Net Provider, how to know what is the session id/number of the session/connection created ?   Thank You. Shiv.
519 Dec 2011 @ 04:35 PSTDatabaseReplyOptimizing Between clause operation. I looked into the Period data type. Created a table as below : CREATE multiSET TABLE t12 (a INTEGER,b PERIOD (date) FORMAT 'YYYY-MM-DD' NULL) PRIMARY INDEX(a) PARTITIO...
412 Dec 2011 @ 08:29 PSTDatabaseReplyOptimizing Between clause operation. Selectivity is 50% (sounds high to me). Here is what i did on 2 tables: Created individual indexes on start_date and end_date. Created combined index on start_date and end_date....
307 Dec 2011 @ 12:25 PSTDatabaseReplyOptimizing Between clause operation. .. interesting point. Can you help me understand the period data type which can replace the start_date and end_date ? any example/blog/url will help. I am trying NUSI, but they are not used ...
207 Dec 2011 @ 07:39 PSTDatabaseReplyOptimizing Between clause operation. I am on 13.10.
106 Dec 2011 @ 07:54 PSTDatabaseTopicOptimizing Between clause operation. All, I have a table T1 which has about 200 M rows and it is a type 2 table (so contains Start_Date and End_Date for every row).   I want to optimize the below conditio...