For a given value of natively

For a given value of “natively”… | Carsten’s Random Ramblings

A quick (but somewhat simplistic) way to test performance of different methodologies is to turn off the query cache and use the BENCHMARK function. BENCHMARK loops over an expression a given number of times, and always returns 0, which is in itself quite uninteresting. But we can then look at the execution time to see how long things took.

I love it when the verbose expressions turn out wicked fast.