What is Join index. When we go for Join Index. IS there any relation Between Oracle Materialized View and Teradata Join index.
You can find the details in the TD documentation, but on a high level Teradata Join Index pre-joins the result of two or more tables and stores it in the permanent DB space and are normally used to speed up the queries using the joined tables by returning the results (if possible) from the join index without going to the base tables. On the other hand, the Join Index are updated whenever the base rows of the joining tables are updated.