Can someone please explain me the architectural difference between the way UNIQUE and NON UNIQUE indexes work? I would like to know if there are acrhitectural differences between the two.