#DateForumTypeThreadPost
1401 Jun 2009 @ 02:57 PDTDatabaseReplyTeradata PI and SI restrictionsHi Adeel,I am aware that there may not be a case wherein you will have more than 64 columns in your index definition.Actually I am looking for what is causing(limitation) Teradata to define this re...
1301 Jun 2009 @ 02:23 PDTDatabaseTopicTeradata PI and SI restrictionsWe know that we cannot include more than 64 columns in PI or SI definition.Can somebody come up why exactly this restriction.Thanks in advance,raj
1226 May 2008 @ 07:48 PDTDatabaseReplyForeign KeyHi,Thanks a lot....Rajan
1126 May 2008 @ 07:02 PDTDatabaseTopicForeign Keyhi,is there a way to find out whether a table is defined with a foreign key or not???I know that one way is to look up the table definition, but i wanted some other means to check if its defined wi...
1009 May 2008 @ 04:29 PDTDatabaseReplyHow to get pagination in Teradata..??use rank function and use qualify to choose the results.example:my_customer is a table with cust_no as UPIfirst hundred records can be got by this query:select cust_no, name, rank(cust_no) as row_i...
908 Feb 2008 @ 02:17 PSTDatabaseTopic"Expalin" explaination neededHi,i have trouble in understanding the different explain plan messages like the one below 1) We do a single-AMP ABORT test from DBC.DBase by way of the unique primary index. what doe...
822 Nov 2007 @ 03:14 PSTDatabaseReplyGaps in values for identity columnsHi Annal,Thanks for the reply, the same problem(Gaps) occurs if you perform the Merge Into operation on a table with an identity column.ThanksRaj
715 Nov 2007 @ 04:38 PSTDatabaseTopicGaps in values for identity columnsI was working with the identity attribute and for my surprise I got gaps in my inserted values.here is what i did:[color=#001133]create table sv_curr( id integer generated always as identity(minval...
605 Oct 2007 @ 03:27 PDTDatabaseReplyHow to increase Number of sessionsThnx...
527 Sep 2007 @ 07:51 PDTDatabaseReplyImpact of Renaming a Table !!!Hi,to get the answer u could have tested ur self.Here is the answer:Whenever u create a table from other table the indexes will be copied not the statistics. so u have to collect statistics separat...
427 Sep 2007 @ 07:36 PDTDatabaseTopicHow to increase Number of sessionsCan anybody tell me how to increase number of sessions in teradata.
329 Jun 2007 @ 03:18 PDTToolsTopicTPump ConnectivityHi1 Can TPump be used to directly use the data from OLTP source systems like ORACLE rather than input data files? if yes How.2 Can TPump be used with Message Queue series? if yes How.Th...
217 Jan 2007 @ 03:12 PSTDatabaseReplyMore elobarate on PPIThanks Dietergot the stuff i was looking forrajan
117 Jan 2007 @ 01:08 PSTDatabaseTopicMore elobarate on PPIhii wanted to know(internals) how actually the ordering occurs when u use ppi...