The goal is to improve the performance of some very slow REPLACE, SELECT, and LOCATE statements whose performance is terrible on these large tables. The methods that I'm trying to improve performance on are preexising and I'm not trying to rewrite them..I'm just trying to speed up the slowest parts of it and indexes seemed the natural way to improve the performance.

As far as the real reason behind using such a large index..I have various information during various parts of the program and thus need to find a way to "search" through the views on different criteria...