Too many small files from updates

pradeepvatsvk
New Contributor III

Hi ,

I am updating some data into a delta table , each time I  only need to  update  one row due to which after every update statement it is creating new file, How do I tackle this issue , it doesn't make sense to run optimize command after every update command