# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
7 | 13 May 2016 @ 10:48 PDT | Tools | Reply | TPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>'; | Really good script Nelluri. Will surely come in handy. |
6 | 27 Jun 2013 @ 01:33 PDT | Connectivity | Topic | How 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. |
5 | 19 Dec 2011 @ 04:35 PST | Database | Reply | Optimizing 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... |
4 | 12 Dec 2011 @ 08:29 PST | Database | Reply | Optimizing 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.... |
3 | 07 Dec 2011 @ 12:25 PST | Database | Reply | Optimizing 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 ... |
2 | 07 Dec 2011 @ 07:39 PST | Database | Reply | Optimizing Between clause operation. | I am on 13.10. |
1 | 06 Dec 2011 @ 07:54 PST | Database | Topic | Optimizing 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... |