#DateForumTypeThreadPost
2408 Jan 2015 @ 10:32 PSTDatabaseReplySpace saved using Compression is exceptionally different from calculated result..Hi, I wanted to know how much i can save using the MVC on multiple columns in a table.  I am taking a example. In TD 12 I am having a table A of 50 GB. Going to compress demical(18,2) co...
2308 Jan 2015 @ 10:31 PSTDatabaseReplyMulti-Value compression has increased the table sizeHi, I wanted to know how much i can save using the MVC on multiple columns in a table.  I am taking a example. In TD 12 I am having a table A of 50 GB. Going to compress demical(18,2) colum...
2218 Nov 2013 @ 02:49 PSTDatabaseReplySynchronized scanningHi, Whether the synchronized scan work for PPI tables also?
2116 Nov 2013 @ 09:54 PSTDatabaseReplyTable CopyHi Dieter, When i create a big table using "create table as" what is the impact on the transient journal? Whether the TJ is loaded with all the data or its like insert select into the em...
2015 Nov 2013 @ 06:49 PSTAnalyticsReplyINSERT SELECT and other valuesHi Raja, Thanks for your valuable comments. In my case i am going to add two new columns into the huge table of 200 million rows. So i am planning to rename the existing table and create a table ...
1914 Nov 2013 @ 09:51 PSTAnalyticsReplyINSERT SELECT and other valuesHi, Can someone tell me the advantage of using insert select into the empty table. Whether its I/o wise useful or CPU wise useful?
1808 Nov 2013 @ 10:21 PSTDatabaseReplyCan You Limit Number of Sessions Per User ?Hi, I am using TD 12. An application is firing 60 concurrent queries. Our SLA is 10 seconds for a query but its taking 20 secs to execute a query. If we increase the number of sessions for a query...
1702 Nov 2013 @ 11:08 PDTDatabaseReplyFallbackHi Dieter, I am using TD 12. When i created a user via TD Administrator, i saw in the create user script fallback and permanent journal options are available. This means that all the fallback, PJ ...
1625 Oct 2013 @ 12:09 PDTToolsReplyInsert select in MloadHi, I am having a requirement like this. Need to load the data from file to sales table, which dont have any additional index. Can i load directly from file to table using MLOAD. Or, can i lo...
1522 Oct 2013 @ 11:28 PDTDatabaseReplyIs Mload better than Insert Statement?Hi, I am having a requirement like this. Need to load the data from file to sales table, which dont have any additional index. Can i load directly from file to table using MLOAD. Or, can i load ...
1404 Aug 2013 @ 09:02 PDTDatabaseReplyUNION Vs MSRThank you very much Dieter, Got clarfied and started reading the DML document.  
1303 Aug 2013 @ 05:09 PDTDatabaseReplyUNION Vs MSRHi Dieter, Thanks for the reply. This means that, Customer table is locked for access and order table is locked for read.  Having one more doubt, if this is the case in the first question i...
1202 Aug 2013 @ 08:41 PDTDatabaseReplyUNION Vs MSRHi Dieter, Thanks for your reply. Now this came into my mind. Locking table customer for access Sel c.*,o.* from customer inner join orders on <conditions> ;Sel c.*,o.* from custome...
1101 Aug 2013 @ 10:09 PDTDatabaseReplyUNION Vs MSRHi, Consider this MSR statements. This involves 2 tables customer and orders Locking table customer for access Locking table order for access Sel c.*,o.* from customer inner join orders o...
1028 Jul 2013 @ 04:37 PDTToolsReplyTpump- Pack factor and sessions ?Hi, For this scenario... TPUMP is doing updates to the PPI table on daily basis. Whether the serialize on multi session TPUMP works fine? My basic question is to understand whether the Serialize...
928 Jul 2013 @ 04:36 PDTToolsReplyTpump - Serialize ?Hi, TPUMP is doing updates to the PPI table on daily basis. Whether the serialize on multi session TPUMP works fine? My basic question is to understand whether the Serialize work on multiple sessi...
818 Jul 2013 @ 06:00 PDTUDAReplywhy should we use SET table ?Hi Fred, Thank you very much for your response. Whether FLOAD performs the duplicate rows check for the SET tables also?And also is there any limitations to load the SET table? Please advise &nb...
717 Jul 2013 @ 05:22 PDTUDAReplywhy should we use SET table ?Hi, I am using TD12. I am having three questions regarding the SET tables. 1.Whether a NUPI slow down inserts into the SET tables? 2. Is there any limitation in number of index for set tables load...
615 Apr 2013 @ 10:35 PDTDatabaseReplyHow to find a particular table in Teradata is locked using SQL query?Thanks Dieter. Got clarified now.
514 Apr 2013 @ 01:00 PDTDatabaseReplyHow to find a particular table in Teradata is locked using SQL query?Hi, Whether the MLOAD HUT locks can be viewed using SHOWLOCKS utility? Please advise.
430 Mar 2013 @ 10:11 PDTToolsReplyusage of check point in fastloadHi, While loading a empty table using Fload, in Acquisition Phase (Phase 1) getting database full error, later i added some more space to the database. Now what can be done complete...
321 Mar 2013 @ 09:29 PDTToolsReplyImproving Loading Mechanism using FastloadHi Feinholz, I must have load multiple input data files as they appear in a Unix file directory using asingle load operation. Is the TPT supports this? Thanks in advance.
221 Jan 2013 @ 05:41 PSTDatabaseReplySecondary IndexHi Dieter, Thanks for your response. I tried this one created a table with single column NUSI and collected stats on the index. Then i dropped the index, still i able to see the stats using help s...
117 Jan 2013 @ 05:54 PSTDatabaseReplySecondary IndexHi, Say, a table is having one column NUSI and stats are collected on that index. What will happen to stats when the NUSI is dropped?