This topic must remain unresolved, unaswered, until I receive a phone callThe issue is IMHO not a SELECT * query. This is done by any tool I know, when you simply use the data grid of the GUI. The SELECT * itself is not bad since SQL Developer only fetches a configurable amout of data until the user requests more, e.g. by scrolling. But - when a sorting of the data is requested, then a full table scan might occure, when the sorting is done on an unindexed column. This might happen unintended as described above.