Welcome! Teradata Developer Exchange is a community-oriented tech website that connects Teradata engineers with developers and customers who are building and deploying solutions on our platforms. Think of it as a digital community of technical experts sharing ideas, code, best practices and lessons on solving problems. Sounds great doesn't it? So sign up and join the community now!

Expand All Syndicate content The Latest
Removing Multi-Column Statistics – A Process for Indentification of Redundant Statistics

This article delves into the potential excessive use of Multi-Column (MC) Statistics and a process for identifying those that are not providing benefit and should be removed. This will reduce complexity and save resources on the re-collection of these redundant statistics.

4 2
Getting Started with Teradata Plug-in for Eclipse

At this point you should already be familiar with Eclipse. But if you are not, Eclipse is the de facto integrated development environment (IDE) for developing Java applications. It provides comprehensive support for Java technologies, as well as a platform for plug-in tools to extend its capabilities. Teradata Plug-in for Eclipse extends the Eclipse IDE with plug-ins that support Teradata application developers.

8 0
Controlling the Flow of Work in Teradata

When you push too much paper into your shredder, it jams; when you pour too much coffee into your cup, it overflows; when you eat too much food, you…well, you know. Everything’s got limits.

One thing that grabbed my attention when I first joined Teradata back in '88, and that I still find striking today, is how the database manages the level of work that enters the system. Managing the flow of work inside Teradata is decentralized, low-effort, and scalable, exhibiting control at the lowest possible level—at the AMP.

Teradata Plug-in for Eclipse 13.01.00

Teradata’s latest and greatest Eclipse offering has been released, and is available in the Teradata Developer Exchange download section (Eclipse_13.01.00).  Further, the 13.01.00 release builds on the 13.00.00 offering by boasting increased functionality.

4 3
Raising Intelligence - Viewpoint Shared Portlets

In the spirit of "Tis better to give than receive" comes the next blog on cool Viewpoint features, that being the ability to "share" a portlet. The shared portlets feature captures a customized version of a portlet and allows it to be shared as a distinct portlet for use by other Viewpoint users. It will appear in the admin menus as its own portlet including the same permissions options as the original portlet it was derived from. One may ask how does it work? And why would one use it?

Teradata Plug-in for Eclipse 13.01.00

The Teradata Plug-in for Eclipse is based on the Eclipse plug-in framework and Data Tools Platform (DTP). Teradata Plug-in for Eclipse enables Eclipse DTP to operate with the Teradata Database and value-added features.

Teradata Geospatial Import/Export Utilities 1.2

Teradata Geospatial Import/Export Utilities 1.2 for Teradata 13.0 (Windows / Linux). For background information on Geospatial, see What can I do with Teradata’s Geospatial Support? And for community support, visit the Connectivity & Extensibility forum.

Recap: October on Developer Exchange

October has been the busiest month yet on Developer Exchange, with an array of new content around Cloud Computing, simultaneous with announcements at our Partners 2009 conference. Where to start? Firstly, Mike Riordan introduces the Teradata Express 13.0 family, which is available in Windows and VMware versions.

Raising Intelligence - Viewpoint DCS Usage

After a spectacular Teradata Partners Conference, I'm back to do another cool Viewpoint features blog. I want to start out on this one with a little background on how this feature came about. In our first two Viewpoint releases, we focused on Teradata Management and Teradata Self Service aspects. Our customer base increased and with that, so did the importance of Viewpoint in the Teradata customer infrastructure. With that increased base and importance, it became clear that we needed to improve on the management aspects of the Viewpoint Appliance itself.

Can We Speak Confidentially? Exposing Explain Confidence Levels

I gave a presentation at the Teradata Partners Conference last week on the fundamentals of collecting statistics, where I touched briefly on the rules behind confidence levels. I’m using this article to go into further depth, and offer you more examples of how these confidence levels come about. If you look at query plans much, I’m confident you’ll find something of interest in this article.

13 10