I have seen the following documentation that details how you can work with the OPTIMIZE function to improve storage and querying efficiency. However, most of the documentation focuses on big data, 10 GB or larger.

I am working with a ~7million row dataset that is 211 MB. Without any of my intervention, this delta table dataset was split into 70 files. When I run the OPTIMIZE command on it, it collapses into 1 file. Did running the OPTIMIZE function help or hurt me in terms of efficiency? And if it hurt me, what is an alternative method for improving efficiency, particularly with respect to reading/querying? Thank you!