I’m using S3 select to query my csv files in S3 but i notice it takes long time (1s>) to retrieve a single record. I was wondering if I can plug an another AWS service with this to speed up my queries. I’d like some code sample as I’m new to AWS

I tried looking to see if there is any to add indexes using S3 select but unfortunately that’s not supported