case studies and performance benchmark
Do you have case studies and benchmark tests on Vertica for star schema joins and aggregate queries where fact tables are >1B and dimension tables are >100M records that I can access? If it's not public or free information, will I be granted access if I have a license/contract number with Vertica?
My objective here is I want to know what is normal processing time and resource consumption for Vertica for huge tables on join and aggregate operations. I want to be able to look at the explain plan (verbose) and see resources consumption and say, this is too much for this operation, there's something wrong.