Let be a distance-regular graph with valency and diameter . It is well known that the Schur product of any two minimal idempotents of is a linear combination of minimal idempotents of . Situations where there is a small number of minimal idempotents in the above linear combination can be very interesting, since they usually imply strong structural properties, see for example -polynomial graphs, tight graphs in the sense of Jurišić, Koolen and Terwilliger, and 1- or 2-homogeneous graphs in the sense of Nomura. In the case when , the rank one minimal idempotent is always present in this linear combination and can be the only one only if or and is bipartite. We study the case when for some minimal idempotent of . We call a minimal idempotent with this property a light tail. Let be an eigenvalue of not equal to and with multiplicity . We show that Let be the minimal idempotent corresponding to . The equality case is equivalent to being a light tail. Two additional characterizations of the case when is a light tail are given. One involves a connection between two cosine sequences and the other one a parameterization of the intersection numbers of with and the cosine sequence corresponding to . We also study distance partitions of vertices with respect to two vertices and show that the distance-regular graphs with light tails are very close to being 1-homogeneous. In particular, their local graphs are strongly regular.