Teradata Tips – The Query Optimizer Likes Simple SQL
This is the second of our ‘Teradata tips’ series. Enjoy! We all know that Teradata SQL is easy to write, right? Sadly, bad SQL is even easier to write. By ‘bad’ SQL we mean SQL that generates an inefficient query plan. No matter how we submit a Teradata SQL query, whether we use SQL Assistant […]
The Teradata Primary Index (PI)
So you think you know about the Teradata primary index (PI)?
Teradata User Group (TUG) – London, 121114
Did you attend the Teradata User Group (TUG) in London?
Lies, Damned Lies and Teradata Statistics
Teradata statistics collection is a topic that many will feel has been done to death. Although this is true, there still seems to be a lot of misunderstanding as to the benefit, or otherwise, that Teradata statistics deliver, especially when put in context of the cost of collection/maintenance. First of all, let’s consider why Teradata […]
Teradata Indexes – primary index (PI) deep dive
Whilst at the Teradata Partners 2011 show last October we bought several copies of a book on Teradata indexes called ‘Teradata Database Index Essentials’, written by Alison Torres of Teradata, no less. This book on Teradata indexes even has it’s own web site at http://www.teradataindexes.com/. So, predictably, we raced each other to read the Teradata […]
Big Data – ebay @ Teradata Partners 2011
So, a few days ago, we were talking through various consulting engagements we’ve had over the years…the kind of marketing collateral discussion you just can’t avoid, no matter how hard you might try! Some of the bigger systems we’ve encountered are at the likes of Vodafone, Verizon, BT and Nokia. All are big in their […]
Teradata Appliance Musings
Some would suggest, quite reasonably, that Teradata has been an appliance ever since it’s birth in the 1980’s. I would tend to agree, sort of. Server, storage, OS, DBMS, cabinet…it’s all there pre-configured and ready to go. Isn’t it? Well, yes, but…there has always been quite a bit of latitude when choosing the spec of […]