Join Index

General

Join Index

Hi 

At what situation or condition PE decide to take the data from the  JOIN INDEX  or  from the normal join.

Thanks

1 REPLY
Enthusiast

Re: Join Index

If your sql is covering sql. ie all columns needed to process the query are present in the existing index.

If a query refers to only columns that are part of the index, Teradata would decide to read the Index subtable rather than looking up the base table