#DateForumTypeThreadPost
90308 Feb 2011 @ 12:55 PSTDatabaseReplySuggestion for a query..i didn't mean the number of rows per partition, although now i know that there's almost 10 percent of the row in the UNKNOWN partition :-) What's the approximate avg/max number of rows for each ...
90208 Feb 2011 @ 11:27 PSTDatabaseReplyVarchar to date conversion - interesting observationThe NULL doesn't cause any issue, the format is correct, too, it's your data, which is faulty. A common solution to this problem is to avoid the typecast on column_a: SELECT column_a, calendar_...
90105 Feb 2011 @ 03:04 PSTDatabaseReplyPerformance imprvt in a queryAdditional to sb42's comment, you could do the count before the join: UPDATE table1 SET STAT='R' WHERE STAT ='O' and id in ( select id from table2 b where eid in ( select eid from table3...
90005 Feb 2011 @ 02:25 PSTAnalyticsReplyRow counts for every table in a given databaseYou can extract the row counts from the statistics collected on those tables. If stats are up to date, this needs no additional overhead. Dieter
89905 Feb 2011 @ 02:18 PSTUDAReplyI need a query to list the table names used in a view. I wrote this SP a few years ago populating a Global Temp Table, a recursive query should be possible, too. Depending on what you actually need a SHOW SELECT * FROM view1 could be sufficient. ...
89805 Feb 2011 @ 02:06 PSTDatabaseReplySuggestion for a query..Why do you want to create an index on end_dt? This seems to be the partitioning column for TX0305_ACCT_BAL_TYPE_DD. Updating it is the same as delete (step 8) and re-insert the rows (step 9). B...
89731 Jan 2011 @ 01:18 PSTDatabaseReplySTJI is not using....There's no WHERE-condition, so even if you included more columns/ROWID in the JI, the optimizer will no use it unless it's fully covering the query. Do you actually need that join using COALESCE? ...
89629 Jan 2011 @ 09:31 PSTDatabaseReplyOPTIMIZED QUERYWhy did you write those Left Joins? Does this query actually return the correct answer? Most DISTINCTs are probably not neccessary, instead of rewriting you should better remove them. What's...
89529 Jan 2011 @ 08:47 PSTGeneralReplyProblem PostingI'm using FF all the time and never had a problem. Maybe try to empty the cache. Dieter
89429 Jan 2011 @ 08:46 PSTDatabaseReplyTABLE SIZE"dramatically smaller", 100 GB to 50GB or 100MB to 50MB? If those are small tables, then it might be due to the overhead of the table header per AMP. Dieter
89325 Jan 2011 @ 02:36 PSTDatabaseReplySTJI is not using....How does the JI look like? There's no where-condition in your query, so why do you think the optimizer should use it? Dieter
89225 Jan 2011 @ 02:31 PSTDatabaseReplyDatabase Access Logging/ReportingHi Paul, what you need is the Access Log but not DBQL, e,g: BEGIN LOGGING WITH TEXT ON FIRST AND LAST ALL ON DATABASE dbname; Check the Security Administration manual for details, Chapter 1...
89123 Jan 2011 @ 12:31 PSTDatabaseReplyTemporal capability and transaction-time ...Hi Rolf, i agree, too :-) I didn't think about the select part, of course you would loose that easy way to query the table if you omit AS TRANSACTIONTIME. But if you want to keep the original ...
89022 Jan 2011 @ 01:46 PSTToolsReplyRegarding Temporary SpaceThe main difference between Spool and Temp is the behaviour during a restart: When Teradata crashes, Spool is discarded, but Temp is recovered. Clients can reconnect the previous session within a...
88921 Jan 2011 @ 02:43 PSTDatabaseReplyTD 12 Demo testMost of the answers 1 to 18 are quite similar, plain rubbish. At least you got "100% satisfaction guaranteed" :-) Dieter
88821 Jan 2011 @ 12:58 PSTDatabaseReplySuggestion for a query..Did you actually check (using DBQL data) which steps consume most resources? If the target table TX0305_ACCT_BAL_TYPE_DD is the same you posted in a previous thread, I$_TX0305_877209444 should h...
88720 Jan 2011 @ 11:00 PSTDatabaseReplyShow table command in TD 13You should install the latest patch for SQL Assistant and check if it's still the same issue. Dieter
88620 Jan 2011 @ 10:58 PSTDatabaseReplyNUSI and Explain PlanYou're right. index #4 is the internal number of the NUSI on ParKey. Do a "HELP INDEX Item;" to see those numbers. The PI is always 1 and SIs are 4,8,12,16,... Dieter
88520 Jan 2011 @ 12:45 PSTDatabaseReplyPerformance Tuning....I assume Account_Num/Account_Modifier_Num is actually Acct_Num/Acct_Modifier_Num Time_Period_Cd is defined as NOT NULL in your DDL, but you filter for "and Time_period is null;" PPI on accou...
88420 Jan 2011 @ 12:36 PSTTrainingReplyhow to delete duplicate recordsDid you notice, that the two previos messages where kind of spam and the original post was four years old? Btw, your solution will not work, but remove all duplicate rows. Dieter
88320 Jan 2011 @ 12:32 PSTDatabaseReplyTemporal capability and transaction-time ...Just read carefully: "A transaction-time column records and maintains the time period for which **Teradata Database** was aware of the information in the row" It's "Teradata Database", not "sou...
88220 Jan 2011 @ 12:20 PSTDatabaseReply3798: A column or character expression is larger than the max size.If you concat three lines the maximum length for message is approx. 21000, which should be enough. It's not '0D0A' but '0D0A'XC XC means the previous string is in hex and it's characters. se...
88120 Jan 2011 @ 12:13 PSTDatabaseReplySession infoAny comparison in ANSI mode is case sensitive by default, whereas Teradata mode is case insensitive. Do a SHOW TABLE and check the column definition, it's probably CASESPECIFIC. Now you got t...
88020 Jan 2011 @ 02:42 PSTGeneralReplyusing 'for each' record in a tableThe only 'for each' in SQL is a cursor, which is usually considered as evil. To get help you have to post more info: What means 'failing'? What's your actual query plus DDL and explain Dieter
87919 Jan 2011 @ 10:58 PSTDatabaseReplySession infoHELP SESSION -> Transaction semantics SELECT transaction_mode FROM dbc.SessionInfoV -- maybe SessionInfoVX WHERE SessionNo = SESSION; Dieter

Pages