Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

How to find join indexes defined on your table in Teradata

  1. Forget Code
  2. Teradata
  3. How to find join indexes defined on your table
To find the join indexes that are defined on your table, run the following query: 
  1. SELECT  * FROM dbc.indices 
  2. WHERE indextype='J'
  3.      AND databasename='your_database_name'
  4.      AND tablename='your_table_name'
  5. ORDER BY indexname,columnposition;