Oracle LIKE predicate and cardinality estimations

(Franck Pachot) There are not many ways to access efficiently to table rows. Either you want lot of them, because your predicate is not very selective, and you read the whole table in the fastest you can do. This is Table Full Scan.

Register to Read