The FAQ (for this forum) discusses a few aspects related to this but I would appreciate you own milage on this. I generate a UUID (String) primary key based on J-GUID . My question is, will having a non-numeric PK mean that indexing a table with hundreds of thousands of records become difficult? I am not a DB expert so some feedback would be appreciated. I am sympathetic to other arguments which state that other apps trying to farm data out of the DB will have difficulty passing through a 36 character long key (but then, the counter args is, very rarely does one get a row by its primary key if the PK happens to be some id that represents uniqueness). Cheers -raj    More>>