Write a comment
Writing comments is only allowed to registered users, registration is free and does not require an email address and can be done quickly here.
Writing comments is only allowed to registered users, registration is free and does not require an email address and can be done quickly here.
Test
Hi, I think this is an excellent post. I created the testing program, but it always shows that the CDS is better than the CTE, followed by the normal code, and finally the CTE. In some cases, depending on the number of records, I find that the normal code is better. What do these times depend on?
Hello marbieto,
article is now some years old, so there are some releases gone.It may therefore be that the numbers can no longer be reproduced in this way. The measurement back then was simply to run the code 1000 times in a row to detect differences (also to see some buffer usages).
Greetings Björn