Querying table with no Primary Key

[slimdave]

Originally posted by pando
with that there is no way you can use an index

A fast full index scan might be beneficial, but you might have to hint in order to get oracle to use it.