O'Reilly logo

Teradata Basics for Business Users by Tom Coffing, Leona Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2 – The Teradata Users' Fastest Queries

“Let me once again explain the rules. Tera-Tom books Rule!”

-Tera-Tom Coffing

Which Query is the Fastest?

image

A)

SELECT *FROM Employee_TableWHERE Employee_No = 12345678 ;

B)

SELECT *FROM Order_TableWHERE Customer_No = 12345678 ;

Which query above will be the fastest because it is a Single AMP Retrieve?

Answer - Which Query is the Fastest?

image

A)

SELECT *FROM Employee_TableWHERE Employee_No = 12345678 ;

B)

SELECT *FROM Order_TableWHERE Customer_No = 12345678 ;

Which query above will be the fastest ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required