15.00 - Example Query Request - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Example Query Request

Consider the following SELECT request against these tables.

     SELECT o_custkey, c_name, o_status, o_date, o_comment
     FROM orders, customer
     WHERE o_custkey=c_custkey;

The next few topics examine the query plan for this SELECT request: first without and then with a join index.