I am considering turning this option on. We have very large databases (several TBs) that contain large tables (100,000,000 rows) that are highly OLTP and we think this will benefit us. However, I'd like to capture a metric before and after the change to measure the improvement. What metric would this be? Average compilation time? And how would I capture it?
Thanks in advance.