SELECT vendor_id, cab_type, avg(fare_amount) from trips; This takes ~86 seconds. Ran it multiple times. SIMD is one of the ingredients for better query perfor

SELECT vendor_id, cab_type, avg(fare_amount) from trips; This takes ~86 seconds. Ran it multiple times. SIMD is one of the ingredients for better query performance, but NOT THE ONLY ONE. See this for more info: https://www.youtube.com/watch?v=xJd8M-fbMI0 https://www.youtube.com/watch?v=xJd8M-fbMI0