Pages
![]() |
Hi, I have a large query where there are two window sets, one over year and another over quarter. I think that since teh parttion by and order by clause is same for 1 set of column and another set of columns, this query can be re-written to avoid the partioning on rows being done again and again. Below is the query:
08 Aug 2016
| 6 comments
,
|
![]() |
I have a requirement to fit in 441GB of history data into a table which makes my table bulky and difficult to query. Just to explain it is a fact table and stores amount fields etc. I have a partition on the business date field.
11 Jul 2016
| 7 comments
,
|
![]() |
Hi all,
03 Jun 2016
| 1 comment
,
|
![]() |
I have a transactional dataset which has a date field, my query is whether it is better to bring in the date field into the PI for the table i am using or leave it out. The PI is currently made up of a product unique identifier which is duplicated for each date related to the product.
26 Apr 2016
| 2 comments
,
|
![]() |
Given: a large table; 14/50 fields responsible by one group; the rest by a second group; the need to for 5/14 fields to be used by analysts familar with the large table (ie. large numbers of scripts written against the current large table; business hour performance on this large table is a primary concern. Updates are typically schedule after hours.
11 Mar 2016
,
|
![]() |
Hi all, I have a particular question regarding how the data are stored inside ResUsageSAWT.
04 Mar 2016
| 1 comment
,
|
![]() |
Hi, I am new to teradata learning, I have download vm Express edition for testing purpose, but this is a very limited in performance, i want to test a machine have a little bit big data, ALL i have to face that, when ever i run a query especially with aggregation, i takes lots of mins to perform the resul
27 Jan 2016
| 6 comments
,
|
![]() |
Aster is an analytic discovery application that lets you perform exploratory queries across your data regardless if it is structured or not.
22 Dec 2015
,
|
![]() |
This session focuses on Monitoring for System Performance.
23 Nov 2015
,
|
![]() |
There is "poetic query" that takes forever to run
16 Sep 2015
| 2 comments
,
|
![]() |
Hi,
01 Jul 2015
| 4 comments
,
|
![]() |
Hi Guys, thanks for reading the post. I did do a search for "view on view" and there was no result.
13 Apr 2015
| 1 comment
,
|
![]() |
Hi All, I am trying to debug a query which is taking a lot of time.
16 Feb 2015
| 3 comments
,
|
![]() |
Have you ever wished for a magic wand that could quickly point out the missing, stale, and unused statistics for you?
11 Feb 2015
,
|
![]() |
This presentation reviews the benefits of collecting performance data on the Teradata platform.
15 Dec 2014
,
|
![]() |
SQL performance is vital for driving value from a data warehouse. With today's growing query complexity, optimizing SQL can be a daunting task ...
17 Nov 2014
,
|
![]() |
Performance Diagnostic Method and Tools is targeted to uncover and resolve performance related issues in three primary areas...
06 Oct 2014
,
|
![]() |
Hi all. We use PDCR to archive our DBQL tables - the primary index on the tables is (logdate,procid,queryid) and they are partitioned by logdate.
22 Aug 2014
,
|
![]() |
Typical 2 years Sales Data Mart contains detail and aggregates in order to support time traverse metrics like 4 Week Shipments, 13 Week Shipments and so on...
12 Aug 2014
| 1 comment
,
|
![]() |
What is the difference between simple system view like dbc.tables, X views and V views and which one is better - performace wise?
11 Apr 2014
| 4 comments
,
|
![]() |
Teradata Intelligent Memory keeps the most frequently used, or hottest, data in memory for in-memory performance without the need to purchase enough memory for all of your data.
10 Apr 2014
,
|
![]() |
Hi ,
09 Apr 2014
,
|
![]() |
For a project, we have several groups that will produce numbers using models. Input and output data will be in the DB. Each group is independent and works in their own different way; however, the outputs they produce will need to be combined, aggregated and queried.
24 Dec 2013
| 2 comments
,
|
![]() |
This session gives a close-up picture of what AMP worker tasks are and how they support user work.
12 Dec 2013
,
|
![]() |
Hi Teradatares :-)
06 Oct 2013
| 5 comments
,
|
![]() |
Hi,
17 Sep 2013
| 2 comments
,
|
![]() |
Hi,
18 Jul 2013
| 1 comment
,
|
![]() |
Hi Experts,
10 Jul 2013
| 1 comment
,
|
![]() |
Hi All,
13 Jun 2013
| 5 comments
,
|
![]() |
I have few doubts regarding statistics collection.
19 May 2013
| 1 comment
,
|
![]() |
Have you ever struggled over whether, or how, to use a new database feature? In this presentation, we’ll demonstrate how database query log (DBQL) data can help when it comes to determining candidates for MLPPI (Multi-Level Partitioned Primary Index) as well as the new Columnar Partitioning feature of Teradata 14.
03 Apr 2013
,
|
![]() |
Defining workloads in TDWM may qualify as a TASM implementation but is just a small piece of the puzzle. This presentation will look at this and all the other pieces needed to complete the picture.
21 Mar 2013
,
|
![]() |
Hi All,
14 Mar 2013
| 2 comments
,
|
![]() |
Hi All
27 Feb 2013
| 9 comments
,
|
![]() |
Does Sql have better performance if columns have COMPRESS? If so how does COMPRESS help the performance? Is it because of lesser Spool space?
31 Jan 2013
| 1 comment
,
|
![]() |
Hi everybody,
16 Jan 2013
| 1 comment
,
|
![]() |
I've got Fastload opening a named pipe, and I'm redirecting the output from a SQL*Plus script to the pipe in Windows. I assumed this would be far faster than allowing SQL*Plus to spool the result to a file locally, and fastload to import the flat file. Turns out it's not.
14 Sep 2012
| 1 comment
,
|
![]() |
When I call ResultSet rs = dbmd.getColumns(null, "CUSTDATA", "TRANS", null); it takes 16 seconds to get an answer back on a fairly unloaded system. This table has 27 columns.
This seems to be excesvily slow. Is there anything that can be done to speed this up?
22 Mar 2012
| 10 comments
,
|
![]() |
Hi, could you please let me know whether there will be any difference in performance between the following two queries. As i don't have any internal knowledge about sql, i have this doubt. table A: column alpha has 100 million records
21 Mar 2012
| 2 comments
,
|
![]() |
TPump has been enhanced to dynamically determine the
22 Dec 2011
| 1 comment
,
|
![]() |
|
![]() |
Hi ALL, I am new to Teradata so sorry if my questions seem trivial and obvious for you.
15 Dec 2011
| 5 comments
,
|
![]() |
Do you want to have your Teradata Parallel Transporter (Teradata PT) Stream operator jobs run faster? Are you having difficulty determining the optimal pack factor for your Stream operator jobs? Knowing how to use the Stream operator’s PackMaximum attribute enables you to determine the optimal pack factor and thus improve the performance of your Stream operator job.
22 Nov 2011
,
|
![]() |
|
![]() |
We are looking to do some application performance testing and need to simulate a "real world" environment in which the warehouse is under strain. Are there any tools/scripts out there that folks use to simulate the load typically placed on an EDW where is it generally pegged at 100% all day?
25 Aug 2011
,
|
![]() |
One of the more difficult challenges in database management and administration is determining where and how to implement a new RDBMS feature or function. In this presentation we’ll look at the DBQL data available for evaluation of tables and columns used within a workload and how this data can be leveraged for determining candidates for MLPPI (Multi-Level Partitioned Primary Index).
24 Aug 2011
,
|
![]() |
Everyone is aware of Teradata’s continued commitment to reducing the footprint and resource usage of data by adding compression capabilities and the result on perm space savings and performance, by reducing block size, IO and spool usage.
10 Aug 2011
| 2 comments
,
|
![]() |
Please refer to the following Viewpoint article for Viewpoint performance considerations.
http://developer.teradata.com/viewpoint/articles/teradata-viewpoint-performance-considerations
13 Jul 2011
,
|
![]() |
Teradata Active System Management (TASM) continues to evolve to increasingly higher levels of automation and usability. Come hear what new TASM offerings are available in release 13.x, and how you can best leverage these new features.
01 Jun 2011
,
|
![]() |
Is it a good practice to define a Primary Index on VARCHAR column ? Although I dont see any strange (data type conversions) in explain plans between Join operations on VARCHAR (Primary Index) to CHAR column (Primary Index) since they are from same domain, I just want to understand if this is as efficient as Joins between CHAR to CHAR columns.
17 May 2011
| 6 comments
,
|