Dec 29 2021 11:47 AM
Dec 29 2021 02:43 PMSolution
Jan 05 2022 06:19 AM
One other method is to use the Usage Table.
Usage is an aggregated Table that knows about all the other Tables, so you can query that for better performance (runs in less than half the time on my data).
This is not a big issue for a simple query like these examples, but can help if this ends up being frequent or the query more complex.
Usage | summarize count() by DataType
Jan 05 2022 09:01 AM
Jan 05 2022 11:06 AM