Hello Expert,
I would like to understand which is the difference between Analytical dataset and Relational dataset,
At database level.
Beccause we had an example of a SQL Script view with a cross join that If used as Relational dataset it does OOM error for a simple data preview.
Instead if used as Analytical dataset, it gives a correct preview.

Are there any difference in the execution engines involved?
Thank you
update:
it seems related to the key definition rather than the "Semantic usage".