In a database, incrementing an INT column can lead to contention issues when multiple transactions try to update the counter simultaneously, causing deadlocks and increased query times. To avoid this, developers can use a separate table with a schema similar to `slotted_counters`, where each row represents a unique slot in the counter. This approach allows for parallel updates without clashing and reduces potential concurrency issues.