#DateForumTypeThreadPost
18002 Jul 2007 @ 11:17 PDTUDAReplyBegin Transaction / End TransactionMay be there's something like a DDL or so inside the proc ... :owhich is fine if you are just calling the proc, if you enclose the call in an BT/ET it could fail.Or may be you can paste the code & ...
17902 Jul 2007 @ 06:11 PDTUDAReplyFast/Multi Load & Control CharactersUse fixed width, it's also much faster to load.The issue of space is normally circumvented in unix by using compression utilities (ie ask the source system to send zipped files) and loading them vi...
17802 Jul 2007 @ 12:27 PDTUDAReplyTeraData vs OracleOracle would survive only if your client was looking for purely OLTP based systems. If it's for a DW platform, the obvious choice is an MPP based RDBMS system, of which Teradata is THE leader.I am ...
17729 Jun 2007 @ 02:21 PDTUDAReplyproduct JoinI am also wondering if the conditionAND b.RRtv_year_id in (2007)had an impact on the performance, it was being evaluated separately for each of the OR conditions, which was an over kill ......had i...
17629 Jun 2007 @ 02:06 PDTDatabaseReplyhow to check the space allocated to particular databaseDBC.DiskSpace will give you database space per AMP.DBC.TableSize for tables ...
17529 Jun 2007 @ 01:47 PDTDatabaseReplyChange PasswordFrom Data definitions statements manual.To execute the MODIFY USER statementIF you are … | THEN you must have the DROP USER privilege on …----------------------------...
17426 Jun 2007 @ 06:10 PDTToolsReplyeliminating non-integer charactersYou can either use unix scripting to do that, use an outmod, or use a UDF like this ....../* C program source for UDF, store it under C:\myUDFS\extractdigits.c */#define SQL_TEXT Latin_Text#include...
17325 Jun 2007 @ 12:51 PDTDatabaseReplyDistinct and CASETry if this one works for you.SELECT TRIM(A.STORE_NUMBER) || MAX(CASE WHEN B.STORE_NUMBER IS NULL THEN '' ELSE '*' END )FROM STORES_A A LEFT OUTER JOIN STORES_B BON A.STORE_NUMBER = B.STORE_NUMBER...
17222 Jun 2007 @ 09:11 PDTDatabaseReplyDistinct and CASENot sure if I understood things correctlybut if store number is unique in both tables and you meant to have all store numbers from table A And if that store number's date fell in between start and ...
17122 Jun 2007 @ 05:54 PDTDatabaseReply[HELP] Modify a column name that is also a NUPI Index...I often wondered why there was so much fuss about renaming columns when it was part of an index. It didn't seem to me to involve anything more than updating the DBC.TVFields table(I am often inclin...
17022 Jun 2007 @ 05:37 PDTDatabaseReplySpace saved using Compression is exceptionally different from calculated result..Hmm.... lol that explains why my maths teacher was so mad at me ;-) Hi Dieter, You are right we always have allocation in terms of bytes, so the existing presence bit array byte would suffice for...
16922 Jun 2007 @ 02:11 PDTDatabaseReplySpooled Data - Sharing>>Some questions>>>1) ... multiple users.. In the same session ?Nope, multiple users implies different sessions as different users can't share the same session. Sync scan is available across sessio...
16822 Jun 2007 @ 12:44 PDTDatabaseReplySample without duplicatesI think the trouble is because RANK() returns the same value for same deptno (in this case it's always 1).So I think piggy backing on Dieter's original solution and using ROW_NUMBER instead, things...
16721 Jun 2007 @ 08:05 PDTDatabaseReplySpooled Data - SharingNo, spool is not shared even with in the same user ids different sessions or with in the sessions different requests.There might be some performance help from SYNC SCAN though.
16621 Jun 2007 @ 07:56 PDTDatabaseReplySpace saved using Compression is exceptionally different from calculated result..well if you go by books then you are supposed to get (8-2)bits/8bits * 10000 records = 7,500 bytes free.However, the disk space reported by the DD is not the "actual" space occupied by the rows in ...
16521 Jun 2007 @ 03:03 PDTDatabaseReplyChange PasswordMODIFY USER Myuserid AS PASSWORD = mypass;
16420 Jun 2007 @ 09:19 PDTDatabaseReplyUrgent Help needed in Rank function!!!!some thoughts ...if you were hunting for the money bags ;-) ... you would have to use order by Amount descAnd, if 209 was the highest amt, and you had values209,208,207,.....,201, 200, 200(Tot...
16320 Jun 2007 @ 09:06 PDTDatabaseReplyPerformance of Correlated Subquery!!!considering that there are quite a bit of permutations and combinations, the best way would be to check the explains of both queries to see what's happening (and is the practical way, it's difficul...
16220 Jun 2007 @ 04:21 PDTDatabaseReplyChecksum AttributeI am not sure of the exact reason, but I would presume it has something to do with the fact that Checksums are computed over the blocks belonging to the same table (Which would be practical/easier ...
16120 Jun 2007 @ 02:39 PDTDatabaseReplyChecksum AttributeIt basically specifies the (percentage) amount of data that should be used to compute the CHECKSUM for the table. It's used for detecting data corruption (bad blocks ?)More % sample = More reliabil...
16020 Jun 2007 @ 02:17 PDTDatabaseReplyDoes Teradata have packagesNo, there are no equivalent concept in Teradata.Though there's a concept of Package (wrt UDF) in Teradata, it's different and not the same as the Oracle package concept.
15920 Jun 2007 @ 02:02 PDTDatabaseReplyPerformance of Correlated Subquery!!!I wonder which documents you are referring too ?Explains would tell better as to what the optimizer is cooking up,And given that most of the inner joins and their cor-related are not necessarily "e...
15820 Jun 2007 @ 12:14 PDTDatabaseReplyError when trying to leave a while loopYou can't have Dynamic SQLs in macro, and you can't have DDL's unless it's last statement of transaction.It's ok to have DDL's in a SP, but you can't have it the way you are looking (ie tablename e...
15719 Jun 2007 @ 08:03 PDTDatabaseReplyError when trying to leave a while loopEnd Transaction has to automatically release any locks acquired by the transaction, so ET would result in closing any cursors.What is getting executed as part of the dynamic SQL ?
15618 Jun 2007 @ 07:53 PDTDatabaseReplyPartitioned Primary IndexThis very long thread kind of discussed everything about it ... :ohttp://www.teradata.com/teradataForum/shwmessage.aspx?forumid=9&messageid=6553

Pages