0 - 10 of 10 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>

A lot has been said over the past few years about “clouds” “big data”, “real time data feeds” and “the active data warehouse”. Unfortunately, much of the dialog centered on the technology and management of the data.

The practice of modeling data prior to a data warehouse implementation has long been a pillar of Teradata best practices. Yet the value of this practice is often questioned by those looking for shortcuts.

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 

 

This presentation provides an overview of the optimizations implemented by MicroStrategy to leverage Teradata data warehouses, a brief overview of the MicroStrategy product architecture, and reviews a number of techniques and settings that can help in MicroStrategy implementations with Teradata.

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.