0 - 7 of 7 tags for optimization

This is my query:

There is  "poetic query" that takes forever to run
Kind of looks like this
sel
col1.tb1,
col2,tb1,
(case <condition involving tb1 and tb2>) as "Dcol1",
Sum ( col1.tb3),
sum (col2.tb3 ),
sum (col3.tb3)
etc
from
tb1 left outer join tb2 <condition> LOJ tb3 <conditions>

It's well-known that the application of database optimization techniques can improve query performance.

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
table B: column beta has 45 million records 

 

Have you ever been bewildered trying to tune complex Teradata queries that go on for pages and pages of EXPLAIN text?  This presentation goes beyond "Explain the Explain", to teach strategies and techniques for quickly deciphering the most expensive operations in your queries.  Taught by a 20+ year Teradata veteran, examples of real queries gathered from some of the largest production environments in the world are used.  This is advanced material covered at a quick pace.