Undocumented Query Plans: The ANY Aggregate
- by Paul White
As usual, here’s a sample table: With some sample data: And an index that will be useful shortly: There’s a complete script to create the table and add the data at the end of this post. There’s nothing special about the table or the data (except that I wanted to have some fun with values and data types). The Task We are asked to return…