Thanks for the reply. I attached the explain plan for your review. The three varchars are a necessary join. I'll look into the links you provided.