SPARSE JOIN INDEX in Teradata

SPARSE join index is being created in Teradata as a result of filtering the rows while joining with the multiple tables.
They are a type of Join Index which contains a WHERE clause that reduces the number of rows which would otherwise be included in the index.
All types of join indexes, including single table, multitable, simple or aggregate can be sparse.

Example code:
CREATE JOIN INDEX ind_employee AS
SELECT  A.DEPTno  ,  b.sal
FROM 
dept  A
INNER JOIN
 employee B
ON  A.deptno=B.dept
WHERE A.deptno=20   --- sparse index
PRIMARY INDEX (sal);


Note:
Join Index never allows a Unique Index to be created.

Explanation:
--> Sal is explicitly mentioned as NUPI
--> A filter clause is applied on Dept.DeptNO = 20, which reduces the number of rows ( an Ideal case of Sparse Index )