Explaining the Aster Explain
,
22 Dec 2015
Aster is an analytic discovery application that lets you perform exploratory queries across your data regardless if it is structured or not.
Views - Internal execution steps
,
30 Aug 2015
Hi,
I have a quick question regarding processing of views.
Incorrect Teradata explain estimates
,
11 Mar 2015
| 1 comment
Hi,
I have a query where teradata expain is giving wrong esitmated time though the query is taking very few seconds.
It is estimating 9 mins due to which it is getting throttled. Issue is in step 7. All the stats are ok and refreshed.
Could anyone pleae suggest what might be wrong.
DELETE FROM
Explaining the EXPLAIN for Business Users
,
09 Mar 2015
| 1 comment
Whether you write your own code or it is generated for you, this is a topic that is essential for business users who run SQL queries.
My perception on EXPLAIN was wrong
,
29 Aug 2014
| 1 comment
Greetings experts,
Explaining the EXPLAIN – New Functionality in 14.0 & 14.10
,
17 Mar 2014
This presentation builds on Recorded Webcast # 49911 Explaining the EXPLAIN, which did just that (if you have not viewed, please do so before watching this webcast).
Column parititioning - why does explain show an extra partition?
,
25 Jul 2012
| 1 comment
I've just started playing around with column partitioning in R14. I created a table using a recent example that Paul Sinclair put into a recent Teradata Magazine article:
The Life of a Teradata Query
,
09 May 2012
This presentation follows a Teradata SQL query from its origin at the client through the components of the parsing engine (PE), dispatched execution steps through the BYNET, step execution and file system management in the access module processor (AMP), merge and sorting of the response through the BYNET to the PE, and returning the answer set to the client.
Explaining the EXPLAIN
,
09 Jan 2012
A topic that is essential for all SQL programmers and database designers. This session examines the mysteries of the English text that appears when an EXPLAIN is requested.
Explain Permissions
,
05 Oct 2011
| 5 comments
Is there a permission that will allow a particular user (ME) to execute an EXPLAIN of Sql that updates or inserts into tables or selects from tables that I don't have update or insert or select permissions on? (or creates a table in a database that the "Explaining user" doesn't have permission to)?