#DateForumTypeThreadPost
46613 Aug 2012 @ 03:51 PDTGeneralReplyCost of the query is more Hi kalyan3in, do you expect that others do your job for free? At least I find this kind of approach a bit difficult.  Beside this with the provided info nobody will be able...
46512 Aug 2012 @ 01:10 PDTDatabaseReplyChanging column datatype from DECIMAL(9,0) to DECIMAL(15,0) If the column is not part of an index you can also try the following approach of adding a new column, update the new column and drop  / rename columns create table a_a (a integer, b deci...
46410 Aug 2012 @ 01:46 PDTGeneralReplyTuning the query If information is confidential you should not share it in this forum.  Beside this I still don't know what your issue is.
46310 Aug 2012 @ 01:19 PDTGeneralReplyTuning the query No - you didn't again provide any valuable input before dumping your questions. And open new threads for new questions.      
46209 Aug 2012 @ 01:06 PDTDatabaseReplyConcatenate the last day of the month to a date. It will depend on which datatype your 201001 is Try select '201001' as dt_char, 201002 dt_int, add_months((dt_char!!'01' \ (date,format'YYYYMMDD')),1)-1, add_mo...
46109 Aug 2012 @ 02:49 PDTGeneralReplyTuning the query I don't think you can do much here. Stats infos seems to be acruate. And with these the plan seems to be a good one. The majority of the time seems to be consumed by the aggregation ...
46009 Aug 2012 @ 02:20 PDTGeneralReplyTuning the query The table? Which? Can you run? select count(*) from COMREFDB_DV1.R_FISCAL_MONTH_TO_YEAR  select count(*) from SLSORDDB_DV1.R_BOOKINGS_FMTH where DV_BOOKINGS_TYPE = ...
45909 Aug 2012 @ 01:40 PDTGeneralReplyTuning the query Overall the plan seems reasonable for this SQL assuming the stats infos are correct. The PI for COMREFDB_DV1.R_FISCAL_MONTH_TO_YEAR is missing. How many rows does this table have? ...
45809 Aug 2012 @ 12:55 PDTGeneralReplyTuning the query No, because you didn't share any valuable input!  DDLs, Explains etc... What do you expect????
45709 Aug 2012 @ 12:26 PDTDatabaseReplyIssue regarding Ordered Analytical Functions Try select c, dt1, cast( substr( max(dt1!!cnt) over (partition by c order by dt1 rows between unbounded preceding and current row) ...
45608 Aug 2012 @ 05:11 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clause What do you need this for??? You could use a straight forward derived table   SELECT cast(f1 as char (10)), cast(f2 as char(26)) From ( Sel f1,f2 from table x ...
45507 Aug 2012 @ 02:00 PDTDatabaseReplysyntax for searching by wildcards Try like '__1_'  
45407 Aug 2012 @ 02:09 PDTDatabaseReplyConcurrency Issue How I understand your problem I would expect that  BT / ET plus read lock for the select should solve your issue. But this mean also that you can not load and do the SELECT/UPDATE in pa...
45307 Aug 2012 @ 02:05 PDTGeneralReplyCompression value Limit in TD12 The '' syntax seems to work on my 13.10 system. Can you run the below code and share the result?  CREATE SET TABLE mvc_test1 ( var_type CHAR(1000), id IN...
45207 Aug 2012 @ 01:26 PDTDatabaseReplyMissing record on loading table with Fastload What you descriped is indicating that the serial number process has one dup value. Can you share the file?
45106 Aug 2012 @ 11:59 PDTAnalyticsReplyExamples using the TeradataR package   What kind of examples do you mean? Something like  http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package
45006 Aug 2012 @ 07:30 PDTDatabaseReplyNeed tips to fine tune quey which is running for long So funny - instead of a plain select x,y,z from table you have a complicated view with 231 lines of code accessing >10 tables/views using derived tables and qualify filters etc. did you t...
44906 Aug 2012 @ 05:17 PDTDatabaseReplyNeed tips to fine tune quey which is running for long But without sharing DDLs of the view, explain and stats info etc. nobody will be able to help you...
44806 Aug 2012 @ 04:38 PDTDatabaseReplyNeed tips to fine tune quey which is running for long You didn't poste any valuable info to support you here. So it ends up in guessing... Is the table really a table? Or is it a view? Run a show select * from tablename;  Share...
44705 Aug 2012 @ 07:56 PDTDatabaseReplyvarchar data type space issue nice one :-) But it will not deal with group by - in the meaning that they they will not aggregated to one row -, will it?
44605 Aug 2012 @ 03:10 PDTDatabaseReplyvarchar data type space issue P.S. only chance I see is to add one char at the end of each value (and extend the varchar def by one), e.g. concate a '|' during the load but in this case you would see it all the time....
44505 Aug 2012 @ 02:32 PDTDatabaseReplyvarchar data type space issue this thread might explain how Teradata is dealing with varchars http://www.teradataforum.com/teradata/20060804_222628.htm Beside this I would consider it as a quite ugly implementation t...
44403 Aug 2012 @ 08:05 PDTDatabaseReplyQualifying with rownumber() Yes, it's possible but I am not sure its the best way to do it. Start reading the manuals on the OLAP functions and check the qualify options. If you run into trouble after reading an...
44303 Aug 2012 @ 01:34 PDTDatabaseReplyFailure 2620 The format or data contains a bad character Your need to share the DDL of my_table. It looks like you di some internal data type conversions. It is likely that you fail at sales_amt and / or Tax_AMT. In case these are NULL you map...
44203 Aug 2012 @ 12:37 PDTDatabaseReplyQualifying with rownumber() this is a quite incomplete requirement and makes it difficult to give you the right answer.  select emp_no, max(dept),max(sal),max(date) from yourtable group by emp_no would do what...

Pages