Implications
•For application programmer
–If txn reads many rows in one table, consider locking the whole table first
–Consider weaker isolation (see later)
•For DBA
–Tune for performance: adjust max number of locks, granularity factors
–Possibly redesign schema to prevent unnecessary conflicts
–Possibly adjust query plans if locking causes problems