ESRI whitepaper suggests there is a significant performance hit for using an alt name table. One of our data vendors puts all alt names as duplicate records on the primary street table. The other uses an alt name table. Performance with the alt name table seems better, but there are too many other differences to make conclusions I think.
Is there a known answer to this question: better to have alt names as duplicate features in primary feature class or as alternate name table?
ESRI whitepaper suggests there is a significant performance hit for using an alt name table. One of our data vendors puts all alt names as duplicate records on the primary street table. The other uses an alt name table. Performance with the alt name table seems better, but there are too many other differences to make conclusions I think.
Is there a known answer to this question: better to have alt names as duplicate features in primary feature class or as alternate name table?