#DateForumTypeThreadPost
3115 Jul 2012 @ 07:55 PDTGeneralTopicDifference between Amp's memory & Spool space. Just trying to understand below statement. "A hash join can be performed only if one or both of the join tables can fit into the AMP’s memory, rather than spool. " Spool ...
3021 May 2012 @ 01:07 PDTDatabaseReplyNUSI Subtable Hi dnoeth, When we define particular column as NUSI, Sub table is created with its value & its base row id. Also, both subtable & its corresponding base row would be placed in a same...
2921 May 2012 @ 01:00 PDTDatabaseReplySpool space Thanks sir. Small clarification needed. Let us say if only 20 GB un used PERM space left at SYSTEM level. And there are 2 users in a system. If i run queries in both the users simultaneously...
2820 May 2012 @ 07:56 PDTDatabaseReplystring Matching using teradata sql Assuming that first 5 letters match exactly for similar names..   UPDATE a FROM (   SELECT SUBSTR(Name,1,5) Name,key FROM table    WHERE key IS NULL ...
2719 May 2012 @ 12:26 PDTDatabaseTopicSpool space There are 3 users created under database which has PERM space 50 GB. Each user is allocated 5 GB PERM space & 20 GB Spool space. Now, the PERM Space left in database- 35 GB. I've...
2619 May 2012 @ 11:58 PDTDatabaseTopicNUSI Subtable Hi, So far my understanding about NUSI - Both Base table & Subtable belong to a single row resides on same AMP. - Subtable can only check base-row-id that local to the same AMP. ...
2519 May 2012 @ 11:52 PDTDatabaseReplyDifference between Database and user As per my knowledge, there are no other differences than what you already mentioned. Both user & database are assigned PERM space .
2425 Apr 2012 @ 11:04 PDTDatabaseReplyLeft outer join help @Pveedu:  You can see some thing like "b AND a are joined USING a MERGE JOIN, WITH a JOIN CONDITION OF ("a.EMP_...
2324 Apr 2012 @ 08:24 PDTDatabaseReplyLeft outer join help SELECT  a.Emp_no,a.Emp_name,b.status FROM Outer_table a LEFT JOIN Inner_table b ON a.Emp_no=b.Emp_no WHERE b.Emp_no<>6 ORDER BY 1;    *** Help inform...
2224 Apr 2012 @ 10:47 PDTDatabaseReplyLeft outer join help Thanks dnoeth. Its pretty much clear now :-)
2123 Apr 2012 @ 08:11 PDTDatabaseReplyLeft outer join help Any comparison to NULL results in UNKOWN. This is how teradata works? Or any logical reason behind this? Btw, i will have to go through manual too. Thanks!
2023 Apr 2012 @ 11:28 PDTDatabaseTopicLeft outer join help Hi, I have two tables called outer_table & inner_table outer_table: select * from outer_table order by 1;    *** Query completed. 4 rows found. 2 columns return...
1909 Apr 2012 @ 02:01 PDTDatabaseReplyValue ordered secondary index vs Partitioned primary index I can say its highly selective and this condition is accountable to calculate aggregated data across each period, in a sense this condition is going to retrieve almost 100% data .  
1804 Apr 2012 @ 07:51 PDTDatabaseReplyValue ordered secondary index vs Partitioned primary index Thanks Ulrich for your information. So you meant to say that if i am defining a column to be partition column that is being used in the joins , I need to ensure that the other column in join...
1701 Apr 2012 @ 08:51 PDTDatabaseReplyValue ordered secondary index vs Partitioned primary index Waiting for response :-(
1631 Mar 2012 @ 11:00 PDTDatabaseTopicValue ordered secondary index vs Partitioned primary index Hi, It is taught that both are used for range queries but how to choose between them. Please share your thoughts. Thanks, Mahesh.
1521 Mar 2012 @ 09:14 PDTDatabaseTopicSecondary index -on the fly creation Hi, As we know Secondary index creation will have to bear a subtable creation which some times be an extra burden.What if i create secondary index inside stored procedure before its usage an...
1417 Mar 2012 @ 11:52 PDTDatabaseReplyConversion: Seconds to MM:SS Btw, sort of simplified query i.e,, select cast ( id/60 as integer) !! ':' !! (id mod 60 (format'99.999')) should give me same result.  Did you have any reason to me...
1317 Mar 2012 @ 10:01 PDTDatabaseReplyConversion: Seconds to MM:SS Great Ulrich! it seems to be working. Thanks. -Mahesh.
1217 Mar 2012 @ 11:39 PDTDatabaseTopicConversion: Seconds to MM:SS Hello, I have a  decimal(20,3) field storing data in seconds. I want those seconds to be converted in to Minutes to seconds format. For ex: 555 seconds should be shown as 9:15 s...
1117 Feb 2012 @ 10:26 PSTDatabaseTopicDirect sql query execution vs keeping it inside procedure Hi Guys,   Just noticed one thing. There is a sql query having executed for date range with local variables defined inside a procedure. For this, CPU cycles coming much high compare...
1028 Jun 2011 @ 08:59 PDTDatabaseReplyTable Size issueThats great mnlylin.It helps.
928 Jun 2011 @ 10:34 PDTDatabaseReplyTable Size issueThanks for reply. But i am just wondering how can real time figures such as sales and quantity be specified forehand.These are dynamic in nature. coming to no of rows my table has around 25k.
827 Jun 2011 @ 07:15 PDTDatabaseTopicTable Size issueHi, My table size is growing huge.It has now 200+ fields.FYI its a fact table.I have nothing much to do here to reduce no of columns. I believe we can compress the row size by mentioning part...
719 Jun 2011 @ 10:46 PDTDatabaseReplyCylindrical & Master indexMy guess was right.Thanks a lot paul. Mahesh!

Pages