In terms of SQL performance, Enterprise version provides more options for configuration especially cluster or redundancy configuration but with a higher price tag. If your AF system is large then would recommend enterprise else standard would suffice. Hardware (CPU, Memory and I/O) play major role in read and write operations.
Performance and Scalability :
Lal Babu Shaik
You can check the Hardware and PI System Sizing Recommendations Spreadsheet at the link below:
While SQL Enterprise does have benefits such as online index operation, it may not be necessary if you are either not running the maintenance job to reindex (or if it can be executed during a non-peak time). Thus, if the hardware (cpu, memory, i/o) is sufficient and you are having performance issues, I would recommend reaching out to tech support to determine if the behavior is expected before upgrading to another SQL edition.
Currently we disabled the re-index which I think we need to put it back. Let me check the fragmentation % on the tables and will call Tech support for further assistance. Thanks for sharing the excel. It's very helpful.