mardi 6 janvier 2015

Full table scan - high water mark


When doing a full-table scan, why does Oracle scan all the rows beneath the high-water mark? Doesn't it know that some of the rows have been deleted and that they shouldn't be scanned?





Aucun commentaire:

Enregistrer un commentaire