#DateForumTypeThreadPost
8717 Jun 2010 @ 06:51 PDTDatabaseReplyDELETE FROM PPI - VERY SLOWDo you also have NUSIs and join indexes defined on the table? These will also have to be updated as well. Random?
8617 Jun 2010 @ 06:00 PDTGeneralReplyT@YS new design?Monis, I just think it is very slow, and it has a very non-standard interface that is difficult to navigate. I have not seen any typical Web 2.0 features no rss feeds or anything like that. I...
8517 Jun 2010 @ 12:21 PDTGeneralTopicT@YS new design?What do you think of the new T@YS interface? I have a few thoughts. I was disappointed to see yet another website with a scrolling news bar. I hate to have to sit and wait for news to scroll...
8412 May 2010 @ 02:34 PDTDatabaseReplyNeed help in Optimizing query!Also , You may fing that join indexes may be required to support this query, it may be worth reading up on that. Random
8312 May 2010 @ 02:33 PDTDatabaseReplyNeed help in Optimizing query!Which tool generated this? Can you run an explain so we can see what the optimiser does with it? Also which version of Teradata are you running?
8212 May 2010 @ 01:05 PDTDatabaseReplyOptimizer Lies :) I may now proceed to show my ignorance on things SQL but here goes.... WHERE mil.business_date = '2010-02-01' --(SEL cal_date FROM bidw_sales.d_date d WHERE d.cal_date BETWEEN '2010-02-01' AND ...
8111 May 2010 @ 09:01 PDTDatabaseReplyOptimizer Lies :) Also how skewed is the data? I assume that Business_date is well spread across amps? Random
8011 May 2010 @ 08:59 PDTDatabaseReplyOptimizer Lies :) Do you need to collect Statistics? The optimiser thinks some of these tables have 2 rows? but with low confidence.... Random
7930 Apr 2010 @ 02:05 PDTGeneralReplyTeradata Support RatiosThis is a slightly odd question, if you don't mind me saying. It would totally depend on the size and complexity of the database and is applications, or what you expect a DBA to do. I have seen...
7801 Apr 2010 @ 02:44 PDTDatabaseReplyIs there any automated tool to compress the data in Teradata..It seems such an obvious piece of functionality. I think its such a needless task for a DBA to do, analyse the tables and pick their own compression values..... There should be no tool, to use yo...
7731 Mar 2010 @ 02:34 PDTDatabaseReplyI'm a learner of teradata. And could you advise me How to study teradata?@nycle, I think you are sorted now. I downloaded the trial when I first started in Teradata, and with the one day course I was soon getting up to speed. Once you understand the differences betwe...
7630 Mar 2010 @ 03:10 PDTDatabaseReplyI'm a learner of teradata. And could you advise me How to study teradata?If you have experience of other databases, go on the 1 day initial introduction to teradata course, it will give you an understanding of the differences. If you have no experience of databases, go...
7530 Mar 2010 @ 02:11 PDTDatabaseReplyHow to gain performance in manipulating and querying huge tables ?Gott, I hate to see a posting go unanswered, (Especially mine!) but I think to answer fully people may need a little more information. What is your teradata node configuration? How big is the...
7426 Mar 2010 @ 04:45 PDTDatabaseReplyTD 13@chinaguy, are you using TVS? I have posted a question in the Enterprise section, but had no feedback yet. Would welcome your thoughts!
7326 Mar 2010 @ 04:43 PDTDatabaseReplyCompressing spacesCompression in Teradata is value based, you supply the values you want to compress, but for the whole field. you cannot compress portions of the field, its not as good as you think there. Thus if...
7218 Mar 2010 @ 03:59 PDTUDAReplyTeradata Virtual Storage.Another couple of points on the virtualised storage. It seems to move away from the "Shared nothing" type environment, with Amps sharing pools of disks. I would expect this should reduce perfo...
7118 Mar 2010 @ 03:28 PDTUDATopicTeradata Virtual Storage.Hi, I am interested in any comments from users of Teradata regarding Teradata v13 Virtual Storage. Has anyone successfully implemented it in a live environment? an Active EDW? I am interested ...
7011 Mar 2010 @ 07:42 PSTDatabaseReplyMonitoring Daily Spool space usage.Thanks Dieter, I thought that would be the answer, just didn't want to implement something, if its already there. Random.
6910 Mar 2010 @ 06:11 PSTDatabaseTopicMonitoring Daily Spool space usage.Hi, I need to monitor the spool space used throughout the day (every 10 minutes or so). So I can trend the actual usage over the month. I need to verify that we are using 30% or less or else w...
6822 Feb 2010 @ 02:35 PSTDatabaseReplySkew FactorsKottur, How many distinct values do you have in your PI? Could be the issue here? random
6722 Feb 2010 @ 02:20 PSTDatabaseReplyUsing Views vs. Direct Query!Rana, It may make it easier to query for the users, but would it be better to clean your data before putting it in the Datawarehouse? Its the option I would always go for. It is better to use ...
6613 Jan 2010 @ 04:18 PSTViewpointReplyWhat Teradata products would you like to see in Viewpoint?gryback, Don't mean to be critical or cause offence. In our fairly recent implementation, we had several DBAs onsite, a significant number of Teradata consultants / impelmentation guys on site,...
6507 Jan 2010 @ 02:22 PSTViewpointReplyWhat Teradata products would you like to see in Viewpoint?Is viewpoint the right vehicle going forward? I personally am not too thrilled with it. However I am only a user of it, I am not given permission to tinker with the configuration. The issues I...
6406 Jan 2010 @ 06:49 PSTDatabaseReplyDifference between FilePres and FilePreReadsWe are still on 12 here. It probably means that the 13 documentation is up to date, and corrected from 12. If that is the case then the formula above is actually the overall Cache hit ratio? I...
6306 Jan 2010 @ 01:40 PSTDatabaseReplyDifference between FilePres and FilePreReadsMonis, My understanding of this is that FilePres is the logical read, which every read will do, then the FilePreReads is the number of physical reads to support the logical reads when the cylin...

Pages