As others have stated, it completely defeats the performance purpose, if you need to lookup using another ID.