Eid's again
The ideal situation would be to have an opaque id generated by the process that updates the tables (I am thinking mviews here) this opaque Id can be indexed, one would think, and hibernate would be cheery that it had a real id, and it would be zippy to search.