What are Deadlocks in Teradata? Deadlocks occur when each of two transactions holds the lock on a database object the ...
Welcome to the Blog
Stay tuned with latest news and articles
The latest posts
What is the Teradata TD_WhichMax Function? Each Teradata release adds new SQL features to make our lives easier. While some ...
This article will show a case study from my past projects. It is an implementation in which, from a row ...
Sometimes you can’t avoid implementing a certain functionality by means of a cursor in a stored procedure. Recently I had ...
Teradata summary statistics are introduced with Teradata Release 14 and provide the Optimizer with statistics about the number of rows ...
Teradata ORDER BY and Performance If we chose a simple sort method, all rows would have to be available in ...
In a previous article, Roland explained how to build a data range without touching a physical table by using recursion. ...
Introduction We can often choose between GROUP BY and DISTINCT for aggregations. In terms of content, both options return the ...
Like most relational database systems, Teradata creates a copy of each row modified for most DML statements. Teradata uses the ...
Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]